DB2 FOR LUW / DB2FORLUW / 970 - DB2

When a query has local equality predicate on a simple column 
"tab1.colX = NULL" as well as equality predicate "tab1.colX = 
tab2.colY" where tab1 and tab2 are two different tables or 
quantifiers, the query compilation may return -901 error 
"invalid qnc assignment" and the following compiler error stack 
can be found in db2diag.log: 
 
sqlnr_splitswbox[60] 
sqlnq_qtb::box_opr_split[116] 
sqlnq_pid::update_qnc[100] 
sqlnq_pid::replace_qnc[100] 
 
Note in Oracle compatibility mode "COL=''" is also transformed 
to "COL=NULL".

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10.                      * 
****************************************************************

Replace "COL=NULL" or "COL=''" in ORA compatibility 
mode to an always false predicate "1=0" in the query SQL 
statement.

First fixed in Version 9.7 Fix Pack 10.

keiner bekannt / siehe Local-Fix

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

10.08.2014
17.11.2014
17.11.2014

9.7.FP10