logo  
Google
 

DB2 SQL-Error: -2001

SQLState: 53089

Short Description: THE NUMBER OF HOST VARIABLE PARAMETERS FOR A STORED PROCEDURE IS NOT EQUAL TO THE NUMBER OF EXPECTED HOST VARIABLE PARAMETERS ACTUAL NUMBER EXPECTED NUMBER

DB2 received an SQL CALL statement for a stored procedure. However, the number of host variable parameters supplied on the CALL statement does not match the expected number of host variable parameters. sqldanum The number of host variable parameters as determined by examining the SQLDA. opnum The expected number of host variable parameters as determined by parsing the statement.System action: The statement cannot be executed. Programmer response: If the SQL CALL statement is coded incorrectly, modify the SQL application to provide the correct number of parameters on the SQL CALL statement.

 <-  BACK TO INDEX