DB2 FOR LUW / DB2FORLUW / 970 - DB2

The create function statement fails with a SQL0109 error when  a 
"With UR" clause is included in a query in the function body.

**************************************************************** 
* USERS AFFECTED:                                              * 
* SQL Routine Users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 Fix Pack 9                                * 
****************************************************************

The function will create successfully with the "WITH UR" clause 
removed.  The special register Current Isolation can then be set 
to UR using the command  "set current isolation ur"  Once the 
register is set the function should compile using the new 
isolation level.  For additional information on the Current 
Isolation special register please see the following URL. 
 
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2 
Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0010945.html 
 
For details on the "SET CURRENT ISOLATION" command please see 
this URL. 
 
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2 
Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0010944.html

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 LUW 9.7 Fix Pack 9, the Fix Pack should be 
applied to to server.

not known / see Local fix

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

25.06.2013
06.01.2014
06.01.2014

9.7.FP9,
9.7.FP9