Ansicht
Dokumentation

SQL5031 - &1 from DECLARE VARIABLE not defined or usable as a host variable. ( OS/400 )

SQL5031 - &1 from DECLARE VARIABLE not defined or usable as a host variable. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL5031
&1 from DECLARE VARIABLE not defined or usable as a host variable.

Message Long Text :

Cause . . . . . : Host variable &1 appears in a DECLARE VARIABLE SQL statement, but one of the following conditions exists:
-- No declaration for the variable exists in the source program.
-- The name is not specified correctly (wrong name, misspelled).
-- Qualified name is not specified correctly.
Recovery . . . : Correct the problem and precompile the program again.
-- Verify that &1 is spelled correctly in the SQL statement.
-- Verify that the program contains a declaration for the &1 variable.
-- Verify that the declaration of the variable &1 in the source program is correct and defines a character or graphic variable.
Technical description . . . . . . . . : Specify OPTION(*SRC *XREF) on the CRTSQLxxx command (where xxx=CBL, PLI, or RPG) or specify OUTPUT(*PRINT) OPTION(*XREF) on the CRTSQLxxxI command (where xxx=C, CPPI, CBL, or RPG). Check the cross-reference portion of the listing produced by the SQL precompiler to verify the attributes as determined by the SQL precompiler. If &1 does not appear in the cross-reference or no definition is listed, then &1 is not declared as required by SQL.

Message File : QSQLMSG
Library Message File : QSYS2924


PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.

Length: 3262 Date: 20240328 Time: 212954     sap01-206 ( 3 ms )