|
Problem IC97098
|
Status: Geschlossen |
CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR" |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Create function statement might fail with a SQL0109 error if
function body references CTE (common table expression )
and 'with UR' isolation clause is used |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 LUW Version 105 fixpack 3 *
**************************************************************** |
| Local-Fix: |
execute isolation clause statement before creating the function
(do not combine them ) |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
DB2 LUW Version 105 fixpack 3
The routine using isolation clause and referencing CTE (common
table expression ) will be create successfully |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.10.2013
03.03.2014
03.03.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
