Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


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

SQLCode +236
SQLDA INCLUDES integer1 SQLVAR ENTRIES, BUT integer2 ARE REQUIRED FOR integer3 COLUMNS

Causa:
The value of the SQLN field of the SQLDA should be at least as large as the number of columns being described. integer3 is the number of columns being described.
In the case that USING BOTH has been specified, twice as many SQLVAR entries are needed as the number of columns being described.
The number of SQLVAR entries that are needed to return all of the information about the columns is integer2.

Note: in the case of DESCRIBE INPUT, each reference to column would actually be parameter.

Ação do sistema:
The SQLDAID 7th byte has been set to "on" with a value of 2 indicating that 2 SQLVAR entries are needed for each column. DB2 has not set any SQLVAR entries.

Resposta ao Desenvolvedor:
Increase the value of the SQLN field in the SQLDA to the value indicated in the message (making sure the SQLDA is large enough to support that amount) and resubmit the statement.

SQLSTATE: 01005