DB2 FOR LUW / DB2FORLUW / 970 - DB2

SQL0153N instead of SQL0783N error was returned , if FOR 
statement has unnamed column. 
CREATE OR REPLACE PROCEDURE "DB2INST1"."TEST1" 
( 
        MSG       IN      OUT     VARCHAR2 
) 
IS 
        v_msg VARCHAR2(30); 
BEGIN 
        FOR cur_test in (SELECT 1 FROM  DUAL) LOOP 
                v_msg := 'HELLO'; 
        END LOOP; 
END Test1; 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0153N  The statement does not include a required column list. 
LINE 
NUMBER=8.  SQLSTATE=42908 
 
However, SQL0153N error is incorrect. 
 
SQL0783N is correct error number. 
A duplicate column name or unnamed column was specified in a 
DECLARE CURSOR statement of a FOR statement.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.7 fixpack 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
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 9

not known / see Local fix

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

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

14.01.2013
23.12.2013
23.12.2013

9.7.FP9