DB2 FOR LUW / DB2FORLUW / 970 - DB2

If associative arrays are used within the SQL Procedural 
Language, then under specific conditions, SQL20439N may be 
returned. 
 
The conditions are as follows: 
- Associative array datatype is used within SQL Procedural 
Language. 
- All elements are first removed from the array via the DELETE 
 
function using subset notation (e.g. with "array" represenenting 
the associative array object, such example is 
array.delete(array.first, array.last) ). 
 
- A new element is added to the array later, at a point in time 
when the array is empty. 
 
The complete error message looks like: 
 
SQL20439N  Array index with value "<integer>" is out of range or 
does not exist. 
SQLSTATE=2202E

**************************************************************** 
* USERS AFFECTED:                                              * 
* Associative array users who meet given conditions            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If associative arrays are used within the SQL Procedural     * 
* Language, then under specific conditions, SQL20439N may be   * 
* returned.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install 97FP4 or later which contain the fix, or change      * 
* script to use delete without any indices to delete entire    * 
* contents of the array (e.g. "<array_variable>.delete()").    * 
****************************************************************

Install 97FP4 or later which contain the fix.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

Install 97FP4 or later which contain the fix, or change script 
to use delete without any indices to delete entire contents of 
the array (e.g. "<array_variable>.delete()").

not known / see Local fix

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

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

07.12.2010
19.05.2011
19.05.2011

9.7.FP4