DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* Update to version 10.1 fixpack 5                             * 
****************************************************************

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 10.1 fixpack 5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.11.2014
20.07.2015
20.07.2015