|
Problem IT16271
|
Status: Closed |
JOIN-CONDITION RETURNS SQLCODE -338 WHEN TABLE FROM IMPLICIT CROSS JOIN IS REFERENCED |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Description: The following join-condition results in SQLCODE
-338 during query compilation:
select * from T1, T2 inner join T3 on T3.C1=T1.C1
SQL0338N An ON clause associated with a JOIN operator or in
a MERGE statement |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 11.1 fix pack 1 *
**************************************************************** |
| Local Fix: |
Change the implicit cross join to an explicit cross join, i.e:
select * from T1 CROSS JOIN T2 inner join T3 on T3.C1=T1.C1 |
| available fix packs: |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 version 11.1 fix pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.07.2016
08.05.2017
08.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.1.1.1
|
 |
