Ansicht
Dokumentation

SQL5011 - Host structure array &1 not defined or not usable. ( OS/400 )

ABAP Short Reference   General Material Data  
This documentation is copyright by IBM.


Message : SQL5011
Host structure array &1 not defined or not usable.

Message Long Text :

Cause . . . . . : Host structure array &1 was specified in a blocked FETCH, a blocked INSERT, or a SET RESULT SETS statement. The host structure array is either not defined or is not usable for one of the following reasons:
-- The host variable is not a valid structure.
-- The host structure is not a dimensioned array.
-- The host structure has more than 1 dimension.
-- A member of the host structure array is dimensioned.
-- Elements of the structure are not contiguous.
-- The host structure array used for indicators contains more than 1 element.
-- The dimension of the host structure array used for indicators is not equal to the dimension of the main host structure array.
-- An element of the host structure array used in the SET RESULT SETS statement is a NUL-terminated character or graphic host variable.
-- The date format of a date host variable element of the structure does not match the SQL date format.
Recovery . . . : Correct any of the following and precompile the program again. Ensure that:
-- the host variable structure is a single-dimensioned array.
-- the elements of the structure are contiguous.
-- the host structure array is limited to 2 levels.
-- the host structure array used for indicators only contains 1 element.
-- the dimension of the indicator structure array is equal to the dimension of the main host structure array.
See the DB2 for i5/OS SQL programming topic collection in the Database category in the IBM i Information Center for more language specific information on how to define the host structure in the program.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.

Length: 3262 Date: 20240426 Time: 223054     sap01-206 ( 2 ms )