|
Problem IC97098
|
Status: Closed |
CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR" |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 ) |
| available fix packs: |
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
|
| Solution |
DB2 LUW Version 105 fixpack 3
The routine using isolation clause and referencing CTE (common
table expression ) will be create successfully |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2013
03.03.2014
03.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
