DB2 FOR LUW / DB2FORLUW / A10 - DB2

When db2look generates statements for sourced functions, db2look 
does not wrap the schema and name of the source functions with 
quotation marks. The execution of the script generated by 
db2look fails with SQL0104N if the source function name contains 
special characters like '+', '-', etc. 
 
For example, db2look may generate statement for a sourced 
function like below 
    CREATE OR REPLACE FUNCTION "SCHEMA1"."+" 
                    ( 
                      "SCHEMA1"."INTERVAL_YEAR_TO_MONTH", 
                      "SCHEMA1"."INTERVAL_YEAR_TO_MONTH" 
                    ) 
 
                    RETURNS  "SCHEMA1"."INTERVAL_YEAR_TO_MONTH" 
                        SPECIFIC SQL120925021552703 
                    SOURCE SYSIBM.+ 
(SYSIBM.DECFLOAT,SYSIBM.DECFLOAT) 
 
In the output, the "SYSIBM.+" should be wrapped as 
""SYSIBM"."+"".

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 v10.1 fp3.                                    * 
****************************************************************

Wrap the schema and name of the source function with quotation 
marks, then execute the script.

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Fixed in DB2 v10.1 fp3.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC95504 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.10.2012
22.10.2013
22.10.2013