DB2 FOR LUW / DB2FORLUW / A50 - DB2

When you create an SQL function in a database in which the 
AUTO_REVAL configuration parameter has been set to 
DEFERRED_FORCE, error SQL1224N will occur if any error exists 
in the function header.  For example, the following PL/SQL 
function will cause the error to occur, if user-defined type 
'numberTable2' does not exist: 
 
CREATE OR REPLACE FUNCTION NumbersBetweenPiped( 
  startValue NUMBER, 
  endValue NUMBER ) 
RETURN numberTable2 
PIPELINED 
IS 
  nCounter NUMBER; 
BEGIN 
  FOR nCounter IN startValue..endValue LOOP 
    PIPE ROW ( nCounter ); 
  END LOOP; 
END; 
/

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 Version 10.5 Fix Pack 4.                       * 
****************************************************************

Ensure that all elements in the function header (that is, 
before the first BEGIN statement) are properly defined, valid, 
and have the relevant permissions prior to issuing the CREATE 
FUNCTION statement.  Alternatively, set the AUTO_REVAL database 
configuration parameter to something other than DEFERRED_FORCE, 
to disable create-with-error semantics.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Delivered in DB2 Version 10.5 Fix Pack 4.

not known / see Local fix

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

30.10.2013
08.09.2014
08.09.2014