DB2 FOR LUW / DB2FORLUW / 970 - DB2

A correlation in the TABLE (or LATERAL) keyword of a FROM clause 
of a subselect 
when using in an outer join operator (+) may return SQL0206N. 
This problem occurs 
when the correlated column is from the table whose column is 
used with the (+) 
in the WHERE clause. 
 
For example: 
 
SELECT * 
FROM   T1, T2, TABLE ( F1(T2.C1) ) AS TX 
WHERE  T1.C1 = T2.C1 (+)

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 FOR LUW ALL EDITIONS                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A correlation in the TABLE (or LATERAL) keyword of a FROM    * 
* clause of a subselect                                        * 
* when using in an outer join operator (+) may return          * 
* SQL0206N. This problem occurs                                * 
* when the correlated column is from the table whose column is * 
* used with the (+)                                            * 
* in the WHERE clause.                                         * 
*                                                              * 
* For example:                                                 * 
*                                                              * 
* SELECT *                                                     * 
* FROM   T1, T2, TABLE ( F1(T2.C1) ) AS TX                     * 
* WHERE  T1.C1 = T2.C1 (+)                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Use equivalent ANSI outer join syntax instead of the (+)     * 
* syntax.                                                      * 
****************************************************************

Use equivalent ANSI outer join syntax instead of the (+) syntax

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Use equivalent ANSI outer join syntax instead of the (+) syntax

Vorgänger  : APAR is sysrouted TO one or more of the following: IC87890 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

18.04.2012
07.01.2013
07.01.2013