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 IC67484 Status: Geschlossen

SQL338N IS RETURNED WHEN AN ON CLAUSE OF A JOIN OPERATION REFERENCES
A COMPILED SQL FUNCTION

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
SQL338N IS RETURNED WHEN AN ON CLAUSE OF A JOIN OPERATION 
REFERENCES A COMPILED SQL FUNCTION 
 
Example: 
 
  create table Ta (c1 int); 
  create table Tb (c1 int); 
 
  create function plus10 (x int) 
  returns int 
  begin 
     return x + 10;-- 
  end; 
 
  select Ta.c1, Tb.c1 
  from Ta left join Tb on Ta.c1 = plus10 (Tb.c1) 
  order by 1,2; 
  SQL0338N  An ON clause associated with a JOIN operator or in a 
MERGE statement 
  is not valid.  SQLSTATE=42972
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL338N IS RETURNED WHEN AN ON CLAUSE OF A JOIN OPERATION    * 
*                                                              * 
* REFERENCES A COMPILED SQL FUNCTION                           * 
*                                                              * 
*                                                              * 
*                                                              * 
* Example:                                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
*   create table Ta (c1 int);                                  * 
*                                                              * 
*   create table Tb (c1 int);                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
*   create function plus10 (x int)                             * 
*                                                              * 
*   returns int                                                * 
*                                                              * 
*   begin                                                      * 
*                                                              * 
*     return x + 10;--                                         * 
*                                                              * 
*   end;                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
*   select Ta.c1, Tb.c1                                        * 
*                                                              * 
*   from Ta left join Tb on Ta.c1 = plus10 (Tb.c1)             * 
*                                                              * 
*   order by 1,2;                                              * 
*                                                              * 
*   SQL0338N  An ON clause associated with a JOIN operator or  * 
* in a                                                         * 
* MERGE statement                                              * 
*                                                              * 
*   is not valid.  SQLSTATE=42972                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 2 or above.                     * 
****************************************************************
Local-Fix:
Implement the function as external UDF (e.g. in Language C or 
Java).
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 10 for Linux, UNIX, and Windows

Lösung
Issue has been fixed in DB2 V9.7 Fix Pack 2.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC67552 IC67575 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.03.2010
23.04.2010
23.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList