DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the SELECT list of a result table of a SET operator (e.g. 
UNION ALL, INTERSECT, etc.) references an inline SQL function 
with a scalar aggregate function as input argument, DB2 may 
return SQL0421N or terminate abnormally (SQL1224N). 
 
 
When SQL1224N is returned, the trap file will contain the 
following stack: 
 
Signal #11 
 
sqlnq_sem 
sqlnp_smactn 
sqlnp_parser 
sqlnp_main 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlri_ddl_get_section 
sqlri_ddl_common 
.... 
.... 
 
Examples: 
 
CREATE FUNCTION lws.GETDOCID(docid VARCHAR(254)) RETURNS 
VARCHAR(319) 
LANGUAGE SQL 
NO EXTERNAL ACTION 
DETERMINISTIC 
RETURN CONCAT(CONCAT('{DOCID$',docid), '}') ; 
 
-- Example 1: SQL0421N 
SELECT 'foo' as key 
   FROM sysibm.sysdummy1 
UNION ALL 
SELECT lws.GETDOCID(CHAR(ROW_NUMBER() OVER())) AS key 
   FROM sysibm.sysdummy1; 
 
 
-- Example 2: SQL1224N 
 SELECT lws.GETDOCID(CHAR(ROW_NUMBER() OVER())) AS key 
   FROM sysibm.sysdummy1 
UNION ALL 
 SELECT 'foo' as key 
   FROM sysibm.sysdummy1 ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 v9.7 Fixpack 5 to the server.                      * 
****************************************************************

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
 

Apply DB2 v9.7 Fixpack 5 to the server.  At minimum this fix 
should be applied to the server.

See LOCAL FIX.

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

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

08.12.2010
02.01.2012
02.01.2012

9.7.FP5