PM92052: ABEND04E RC00E70005 AT DSNXGDT2 OFFSET M207 WHEN CALLING TABLE FUNCTION WITH XML RETURNED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • The ABEND04E IN DSNXGDT2 M207 occurs when a table function is
    called and an XML data type is returned.
    
    The fix will be included in the next release of DB2.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of external TABLE function that        *
    *                 uses XML type as return type or parameter.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E70005 MAY OCCUR           *
    *                       WHEN CALLING TABLE FUNCTION            *
    *                       WITH XML PARAMETER or XML              *
    *                       RETURNED                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Following usage of XML type are invalid but it is not caught
    properly which may cause an ABEND04E in DSNXGDT2.
    
     EXEC SQL CREATE FUNCTION F1 (parm1 char(1))
    
              RETURNS TABLE(C1 XML)
              LANGUAGE COBOL EXTERNAL
    
              PARAMETER STYLE DB2SQL
              PARAMETER CCSID ASCII
              ;
    
    
     EXEC SQL CREATE FUNCTION F1 (parm1 XML    )
    
              RETURNS TABLE(C1 char(1))
              LANGUAGE COBOL EXTERNAL
    
              PARAMETER STYLE DB2SQL
              PARAMETER CCSID ASCII
              ;
    
    XML type is not allowed to be used in external TABLE function.
    SQLCODE -451 or DSNH451I should be issued.
    
    Additional keywords:ABEND04E, SQLTUDF, SQLTABLEUDF
     SQLCODE451 MSGDSNH451I SQLFUNCTION
    
    SOLUTION:
    DB2 code is modified so that the proper error, SQLCODE -451
    or DSNH451I will be issued.
    The fix, PM92052, is implemented in the development release.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM92052

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-28

  • Closed date

    2013-08-21

  • Last modified date

    2013-08-21

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

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

Fix information

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM92052

Modified date:

2013-08-21

Translate my page

Machine Translation

Content navigation