DB2 FOR LUW / DB2FORLUW / 980 - 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 v9.8 Fixpack 4 to the server.                          * 
****************************************************************

APAR was originally to be included in v9.8 FP4, but canceled 
since this fix has already been included in v9.8 GA.

not known / see Local fix

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

12.01.2011
25.02.2011
25.02.2011

9.8.,
9.8.FP4,
9.8.FP4