DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare conditions a SQL0779N error might be return if label 
specified in GOTO statement is followed by array collection 
method 
TRIM/DELETE/EXTEND. 
The following example illustrates the problem. 
 
declare 
 TYPE tArray IS TABLE OF VARCHAR2(10); 
 Arr1 tArray; 
begin 
  GOTO LABEL1; 
  <<LABEL1>> 
  Arr1.delete; 
end; 
 
This situation might also occur in case of label being followed 
by assignment of DBMS function like DBMS_SQL.OPEN_CURSOR 
mycur := DBMS_SQL.OPEN_CURSOR ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2 luw                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 v101 fixpack 5                                * 
****************************************************************

Please make sure that label is not followed by array collection 
methods.

upgrade to DB2 v101 fixpack 5

not known / see Local fix

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

28.02.2014
13.07.2015
13.07.2015