SQL - SQLCODE's - Códigos negativos -2001

Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -2001
   
 
  • Causa
    • THE NUMBER OF HOST VARIABLE PARAMETERS FOR A STORED PROCEDURE IS NOT EQUAL TO THE NUMBER OF EXPECTED HOST VARIABLE PARAMETERS.
      ACTUAL NUMBER sqldanum, EXPECTED NUMBER opnum.

      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.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • If the SQL CALL statement is coded incorrectly, modify the SQL application to provide the correct number of parameters on the SQL CALL statement.

      SQLSTATE: 53089
© Copyright IBM Corp.