DB2 FOR LUW / DB2FORLUW / 970 - DB2

Issue: 
 
When using DB2_SELECTIVITY=YES, 
Local variables defined in stored procedures leads to the 
following error: 
 
SQL20046N  SELECTIVITY clause following "" can only 
be specified for a valid user-defined predicate.  LINE 
NUMBER=xx. 
SQLSTATE=428E5

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 Version 9.7 Fix Pack 9.                        * 
****************************************************************

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
 

Delivered in DB2 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97043 IC97062 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.03.2013
19.12.2013
19.12.2013

9.7.FP9