home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC63531 Status: Geschlossen

ERROR SQL0440N IS RETURNED WHILE COMPILING QUERY THAT HAS AN OR PREDICATE
ON USER DEFINED TYPE COLUMN

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* 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) ) );                                             * 
****************************************************************
Local-Fix:
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) ) );
verfügbare FixPacks:
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

Lösung
Manually rewrite the query.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68766 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.10.2009
10.06.2010
10.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version