Stored procedure errors

There are common iSeries Access ODBC errors returned to applications from stored procedure.

• SQL0444 - External program &A in &B not found (DB2 UDB SQL)
  The SQL0444 is generated on an execute or execute direct when the DB2 UDB database server is able to locate the procedure declaration but is unable to locate the program object.

• No data returned on OUTPUT and INPUT_OUTPUT parameters
  For iSeries Access ODBC: SQLBindParameter problem when no data returned

• SQL0501 - Cursor CRSR000x not open
  For iSeries Access ODBC: To return data when using embedded SQL in ILE programs, specify the compile option ACTGRP(*CALLER) and not the default of *NEW.

Parent topic: