DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem may occur if the seed arm of UNION ALL has a typed 
parameter marker and the iterative arm has a specific literal 
value. 
 
Here is the example of the query: 
 
WITH CTE1 (TEST_VAR) 
AS 
( 
SELECT CAST( ? AS CHAR(2)) 
FROM Table (values (1)) 
UNION ALL 
SELECT CAST( 'ab' AS CHAR(2)) 
FROM CTE1 T1 
WHERE T1.TEST_VAR = ?) SELECT * from CTE1 ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 8                             * 
****************************************************************

Use literal values or typed parameter markers for both arms of 
UNION ALL.

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
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC86780 IC91290 IC91796 
follow-up : 

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

20.09.2012
08.04.2013
08.04.2013

9.7.FP8