DB2 FOR LUW / DB2FORLUW / 970 - DB2

The error SQL0153N "The statement does not include a required 
column list" might be reported if all the following 
conditions are met: 
1. create compiled object DDL (function, procedure or trigger) 
2. cursor is explicitly or implicitly declared 
3. cursor references a CTE (common table expression) 
 
 CREATE OR REPLACE FUNCTION   f2 
           RETURN number AS 
        BEGIN 
           FOR I IN (WITH TBL1 AS 
                          (SELECT c2 
                             FROM prof.t2) 
                     SELECT   c2 
                         FROM tbl1 
        ) 
           LOOP 
           END LOOP;-- 
 
           RETURN 1;-- 
        END ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW v97                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version 9.7 fix pack 9                    * 
****************************************************************

REPLACE CTE (COMMON TABLE EXPRESSION ) WITH SUBSELECT 
------------------------------------------------------ 
 CREATE OR REPLACE FUNCTION   F2 
           RETURN NUMBER AS 
        BEGIN 
           FOR I IN (WITH TBL1 AS 
                          (SELECT C2 
                             FROM PROF.T2) 
                     SELECT   C2 
                         FROM TBL1 
        ) 
           LOOP 
           END LOOP;-- 
 
           RETURN 1;-- 
        END ; 
--------------------------------- 
WOULD BE REPLACED WITH : 
---------------------------------- 
 
 CREATE OR REPLACE FUNCTION   F2 
           RETURN NUMBER AS 
        BEGIN 
           FOR I IN ( SELECT C2 FROM PROF.T2 ) 
           LOOP 
           END LOOP;-- 
 
           RETURN 1;-- 
        END ;

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
 

Fix in DB2 version 9.7 fix pack 9, creation of trigger, routine 
is successful

not known / see Local fix

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

22.07.2013
16.12.2013
16.12.2013

9.7.FP9,
9.7.FP9