logo  
Google
 

DB2 SQL-Error: -144

SQLState: 58003

Short Description: INVALID SECTION NUMBER C E SQL SELECT SQLERROR FROM SYSIBMSYSPACKAGE WHERE COLLID AND NAME AND VERSION I C SQLERRORCONTINUE SELECT STMTNO TEXT FROM SYSIBMSYSPACKSTMT WHERE COLLID AND NAME AND VERSION AND SECTNO AND BINDERROR Y I R C REPLACE F I DB SQL Y DB W DBRM SELECT FROM SYSIBMSYSSTMT WHERE SECTNO ORDER BY NAME PLNAME STMTNO SEQNO W SELECT FROM SYSIBMSYSPACKSTMT WHERE SECTNO ORDER BY COLLID NAME VERSION STMTNO SEQNO F E I

One of the following: 1. The user attempted to execute an invalid section. 2. This release of DB2 does not support the SQL statement. 3. The section number in the call parameter list is one of these: v Negative v An invalid duplicate v Greater than the maximum section number of the DBRM or package.System action: The statement is not executed. Programmer response: For case 1: If you are executing a package that was bound with SQLERROR(CONTINUE), determine whether the statement in question was bound as a valid section. You can use the following statements to query the DB2 catalog:

 <-  BACK TO INDEX