DB2 FOR LUW / DB2FORLUW / 950 - DB2

When compiling a query that has an OR predicate on User Defined 
Type column, the following error may be seen: 
SQL0440N  No authorized routine named "<=" of type "FUNCTION" 
having 
compatible arguments was found.  SQLSTATE=42884 
 
The problem is first introduced to v95fp4

**************************************************************** 
* USERS AFFECTED:                                              * 
* Affect all paltform                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ERROR SQL0440N IS RETURNED WHILE COMPILING QUERY THAT HAS    * 
* ANORPREDICATE ON USER DEFINED TYPE COLUMNWhen compiling a    * 
* query that has an OR predicate on UserDefinedType column,    * 
* the following error may be seen:SQL0440N  No authorized      * 
* routine named "<=" of type"FUNCTION"havingcompatible         * 
* arguments was found.  SQLSTATE=42884The problem is first     * 
* introduced to v95fp4                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Manually rewrite the query toselect * from tab1 where ((col1 * 
* between cast (1 as UDF_COL)andcast (1 as UDF_COL) AND col2 = * 
* cast (2 as UDF_COL) AND col3> 3)OR (col1 = cast (1 as        * 
* UDF_COL) AND col2 > cast (2 asUDF_COL) )OR (col1 > cast (1   * 
* as UDF_COL) ) );                                             * 
****************************************************************

Manually rewrite the query to 
select * from tab1 where ((col1 between cast (1 as UDF_COL) and 
cast (1 as UDF_COL) AND col2 = cast (2 as UDF_COL) AND col3 > 3) 
OR (col1 = cast (1 as UDF_COL) AND col2 > cast (2 as UDF_COL) ) 
OR (col1 > cast (1 as UDF_COL) ) );

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

Manually rewrite the query.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC68766 
follow-up : 

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

01.10.2009
10.06.2010
10.06.2010