Ansicht
Dokumentation

SQL0804 - SQLDA or descriptor area not valid. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : SQL0804
SQLDA or descriptor area not valid.

Message Long Text :

Cause . . . . . : If the error type is 2, 3, 9, 12, or 13, the entry in error is &2, the value of SQLTYPE or TYPE is &3, and the value of SQLLEN, SQLLONGLEN, or LENGTH is &4. If the error type is 13, the &5 was being set when the inconsistency was found. The specified SQLDA or descriptor area is not valid because of error type &1. Error types and their meanings are:
1 -- The value of SQLN is less than zero, the value of SQLD is not between 0 and 8000, the value of SQLD is greater than the value of SQLN, or that the value of SQLD has not been initialized in REXX.
2 -- The value of SQLTYPE is either not valid or not supported or has not been initialized in REXX.
3 -- The value of SQLLEN or SQLLONGLEN is not valid or the value of SQLLEN, SQLPRECISION, or SQLSCALE has not been initialized in REXX. If REXX and SQLTYPE is decimal or numeric, then either SQLPRECISION or SQLSCALE has not been initialized. Otherwise, SQLLEN has not been initialized. If SQLTYPE is a LOB or XML variable, then SQLLONGLEN is not valid.
4 -- The attributes in the descriptor for an array variable are not valid. The DATA item in the level 0 descriptor item must not be NULL except when the array is null.
5 -- The SQLDA area was not on a 16-byte boundary.
6 -- The value specified for SQLDABC is not valid. The value is either not large enough for the number of entries specified in SQLN or the value is greater than the maximum allowed.
7 -- The value of SQLN was not at least twice the size of SQLD and LOB host variables were found in the SQLDA.
8 -- The seventh byte of SQLDAID was not a '2', '3' or '4' and LOB host variables were found in the SQLDA.
9 -- The SQLDATAL pointer was not null for a DBCLOB host variable, but the length value referenced by the SQLDATAL pointer had an odd value.
10 -- The SQLTYPE for a LOB locator did not match the type associated with LOB locator.
11 -- The row length is greater than the maximum allowed row length.
12 -- The TYPE for an item in the descriptor area has not been set.
13 -- The attributes of the item in the descriptor area are not consistent. TYPE, LENGTH, PRECISION, SCALE, DB2_CCSID, and DATETIME_INTERVAL_CODE need to be consistent with one another for each item set with the SET DESCRIPTOR statement.
14 -- The value of LEVEL in the descriptor area is not valid.
15 -- The value of DATETIME_INTERVAL_CODE in the descriptor area is not valid.
16 -- Input and output descriptors used on a CALL statement did not match. Both descriptors must include all of the parameters for the CALL and the items must match, except when the descriptors were built by a DESCRIBE of the CALL statement.
17 -- An ARRAY SQLTYPE was specified in an SQLDA.
Recovery . . . : Correct the error in the SQLDA or descriptor area and try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3251 Date: 20240502 Time: 001049     sap01-206 ( 2 ms )