DYNSQL fails to compile with DUP field names
Brought to you by:
dmmorris
Menu
▾
▴
#18 DYNSQL fails to compile with DUP field names
I have attempted to recompile the ISTKT using the BUILD CL. The build fails at the compile of module DYNSQL. The SQL compile report gives the following;
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change Comments
1516 C+ SYSTEM_TABLE_NAME = :Fil And 70700
1517 C+ SYSTEM_TABLE_SCHEMA = :Lib 70800
1601 C+ SYSTEM_TABLE_NAME = :Fil And 79200
1602 C+ SYSTEM_TABLE_SCHEMA = :Lib 79300
DIAGNOSTIC MESSAGES
MSG ID SEV RECORD TEXT
SQL0314 35 1516 Position 38 Host variable FIL not unique.
SQL0314 11 1517 Position 40 Host variable LIB not unique.
SQL0314 35 1601 Position 38 Host variable FIL not unique.
SQL0314 11 1602 Position 40 Host variable LIB not unique.
The compile errors in question occur in producres GetColHdg and GetColInf. The host fields in question are defined unique to each procedure, however.
Logged In: YES
user_id=1780254
Originator: YES
The system release getting the error is 5.4