Ansicht
Dokumentation

SQL0822 - Address in the SQLDA or descriptor area not valid. ( OS/400 )

Vendor Master (General Section)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : SQL0822
Address in the SQLDA or descriptor area not valid.

Message Long Text :

Cause . . . . . : The SQLDA or descriptor area contains an address, SQLDATA or DATA value, or SQLIND or INDICATOR value in entry number &1 that is not valid. The incorrect address or value is type &2.
-- Type 1 indicates that the SQLDATA or DATA address is not valid.
-- Type 2 indicates that the SQLIND or INDICATOR address is not valid.
-- Type 3 indicates that the SQLDA address is not valid.
-- Type 4 indicates that the row storage area is not large enough.
-- Type 5 indicates that the indicator area for a blocked FETCH statement is not large enough.
-- Type 6 indicates that the SQLDATA field was not initialized to a value in a REXX procedure.
-- Type 7 indicates that the SQLIND field was not initialized to a value in a REXX procedure.
-- Type 8 indicates that the SQLDATAL address is not valid.
Recovery . . . : For types 1, 2, 3, or 8, change the address in entry &1 to a valid address. For types 4 and 5, allocate enough area for all of the rows being requested. For types 6 and 7, initialize the SQLDATA or SQLIND fields to a valid value. Try the request again.
Technical description . . . . . . . . : When an SQLDA is used on FETCH, OPEN, or EXECUTE, the address in each SQLDATA entry in the SQLDA must be set to a valid address. If the SQLTYPE value indicates that an indicator variable is also provided, the corresponding SQLIND entry must contain a valid address in addition to the SQLDA being set to a valid address. In the case of a REXX procedure, the SQLDATA and SQLIND fields are not pointers, but are buffers containing the variable and indicator values. When an SQLDA is used on an OPEN or EXECUTE, these variables must be initialized to a valid value.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3250 Date: 20240419 Time: 232038     sap01-206 ( 3 ms )