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
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +238
SQLDA INCLUDES
integer1
SQLVAR ENTRIES, BUT
integer2
SQLVAR ENTRIES ARE NEEDED FOR
integer3
COLUMNS BECAUSE AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A LOB
Causa
Given that at least one the columns being described is a LOB, space must be provided for the
extended
SQLVAR entries in addition to the
base
SQLVAR entries. The value of SQLN,
integer1
, indicates that there are not enough SQLVAR entries for the base and extended SQLVAR entries. One or more of the columns being described may be a distinct type.
n is the number of columns being described which is
integer3
), and whether the columns include any distinct types:
With USING BOTH, and one or more distinct types, space should be allocated for
3n
SQLVAR entries.
Otherwise, space should be allocated for
2n
SQLVAR entries.
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
DB2 has set the SQLDAID 7th byte flag "on" because sufficient space was not provided for the
extended
SQLVAR entries. The value of the 7th byte flag indicates how many 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
integer2
(after making sure that the SQLDA is large enough to support that amount) and resubmit the statement.
SQLSTATE: 01005
