Menu principal                 [Fechar]
Introdução
Divisões
Identification Division
Environment Division
Data Division
Procedure Division
Comandos CICS
VSAM - File Status
Quadros importantes
SQL - Structured Query Language
Outros programas
Rotinas prontas
Palavras reservadas
Introdução ao Oracle
Sites de busca
Sites interessantes
Meu e-mail

SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -2001

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

Conclusão: 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.