PI90500: ABEND04E RC00E70005 DSNXGDT2 M202 WITH EXTERNAL TABLE UDF WITH GRAPHIC DATATYPE PARAMETERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXGDT2 M202 may occur for
  stetements that refers to external table UDF with graphic
  datatype parameters
  
  Example:
  
  CREATE FUNCTION USERFEFINDEFUNCTION(ALL_ROWS GRAPHIC(100) CCSID
  UNICODE)
     PARAMETER STYLE DB2SQL
     FENCED
     RETURNS TABLE (A_ROW   GRAPHIC(100) CCSID UNICODE)
     ..
  
  select * FROM TABLE (
      USERFEFINDEFUNCTION( CAST('00000000060000000002001011002022'
      AS char(100) CCSID EBCDIC ))
        ) as itab
  
  Keywords:
  SQLFUNCTION SQLUDF
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 and V12 for z/OS users of an                      *
  * SQL statement containing an external                         *
  * table function and the output table                          *
  * column is GRAPHIC or VARGRAPHIC                              *
  * data type.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E at DSNXGDT2 M202 could occur                        *
  * for an SQL statement satisfying all                          *
  * of the following conditions:                                 *
  * 1. It contains an external table                             *
  * function.                                                    *
  * 2. The output table column is GRAPHIC                        *
  * or VARGRAPHIC data type.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available.                         *
  ****************************************************************
  An example is shown below:
  
  CREATE FUNCTION MYUDF1 (INVAR1   GRAPHIC (100))
  PARAMETER STYLE DB2SQL
  FENCED
  RETURNS TABLE (C1   GRAPHIC(100))
  LANGUAGE C
  DETERMINISTIC
  NO SQL
  EXTERNAL NAME "FAE"
  SPECIFIC "FAE"
  PARAMETER CCSID EBCDICC
  NO EXTERNAL ACTION
  SCRATCHPAD 100
  DISALLOW PARALLEL
  WLM ENVIRONMENT D6Y0_UTILS
  CARDINALITY 1000
  ;
  
  SELECT * FROM TABLE (
  MYUDF1( CAST( '00000000060000000002001011002022'
  AS GRAPHIC(100)))
  ) AS ITAB ;
  
  DB2 did not correctly process the aforementioned SQL statement
  and can result in ABEND04E at DSNXGDT2 M202.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  SQL statement.
  
  Additional Keywords: SQLUDF SQLTUDF SQLTABLEUDF SQLGRAPHIC
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI53341 UI53350

Modules/Macros

• DSNXOPML
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI53341

     UP18/02/03 P F802

• RB10 PSY UI53350

     UP18/02/03 P F802

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.