DB2 FOR LUW / DB2FORLUW / 970 - DB2

Prior to DB2 Version 9.7 Fix Pack 6, if your application 
attempted to access a federated object from within a compiled 
SQL function, or within a stored procedure that is directly or 
indirectly called from a compiled SQL function, DB2 would report 
error SQL20136N.  As of Fix Pack 6, the error is no longer 
reported when the federated object reference occurs within the 
scope of a compiled SQL function--including any PL/SQL function. 
 
  This is an error:  DB2 does not support federated object 
references that take place in the scope of a compiled SQL 
function.  The failure of DB2 to report the restriction does not 
imply support for federated object references in this context. 
 
  This restriction is documented for external functions in the 
DB2 InfoCenter, but also applies to SQL functions: 
 
* CREATE FUNCTION (external scalar) statement 
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2. 
luw.sql.ref.doc/doc/r0004461.html 
 
  Notes 
  - If the function allows SQL, the external program must not 
attempt to access any federated objects (SQLSTATE 55047).

**************************************************************** 
* USERS AFFECTED:                                              * 
* federated object user                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPack 8                         * 
****************************************************************

Avoid the use of federated objects from within compiled SQL 
functions, or within routines called by compiled SQL functions.

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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 FixPack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC86715 IC91689 
follow-up : 

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

20.09.2012
07.04.2013
07.04.2013

9.7.FP8