Jeff -
It would be helpful to see the full SQL statement which caused this error.
Perhaps if you qualified your field names in the SELECT statement by using
the filename or a correlation name you probably would not get this error, or
you would have discovered it the first time that you tried executing it...
Example:
Select A.Field1, A.Field2, B.Field3 from FileA A
join FileB B on A.Field1 = B.Field1
- sjl
Jeff wrote:
Hi All,
I just got bitten by this error today:
Message ID . . . . . . . . . :
SQL0338
Message file . . . . . . . . :
QSQLMSG
Library . . . . . . . . . :
QSYS
Message ID . . . . . . . . . : SQL0338
Message file . . . . . . . . : QSQLMSG
Library . . . . . . . . . : QSYS
Message text . . . . . . . . : JOIN predicate not valid.
V6R1
Message . . . . : JOIN predicate not valid.
Cause . . . . . : The JOIN predicate is not valid because a column is
specified that exists in a table that is outside the scope of the
join predicate.
The scope is generally determined from left to right but is
also based on the position of the join-condition. If parentheses are
used, columns inside the parentheses can not come from a table outside
the parentheses.
Recovery . . . : Do one of the following and try the request again:
-- Make certain that the column names, table names, and any qualifiers
are specified correctly.
-- Specify parentheses around joined tables to specify a join order
other than left to right. Ensure columns exist in tables that are in the
same scope.
