Ansicht
Dokumentation

SQL0012 - Correlation without qualification occurred for column &1 to table &2. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : SQL0012
Correlation without qualification occurred for column &1 to table &2.

Message Long Text :

Cause . . . . . : Column &1 which occurs in a subselect, is not explicitly qualified, and occurs in table &2 in library &3 specified in the FROM clause of an outer subselect or as the target of an update or delete operation. Consequently, the reference to the column in the subselect is an outer reference, and correlation will occur.
Recovery . . . : Ensure you intended to use the correlation. If you did not intend to use the correlation, the column does not exist in any of the tables or views identified in the FROM clause of the same level of the subselect that column &1 was referenced. Since it is a good practice to explicitly qualify any intended correlated references, it is recommended that the statement be changed so that the column &1 is qualified with a table designator.

Message File : QSQLMSG
Library Message File : QSYS2924


General Material Data   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3251 Date: 20240425 Time: 090034     sap01-206 ( 3 ms )