| |
- Causa
- 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
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
|
| |
