PK64568: ABEND04E RC00E70005 IN DSNXOEM :M310 ON QUERY WITH NOT KEYWORD IN CASE-EXPR ON ORDER BY CLAUSE

A fix is available

 

APAR status

  • Closed as program error.

Error description

  • ABEND 04E-RC00E70005 in DSNXOEM :M310 when running a query,
    which references Not keyword in a Case expression on the
    OrderBy clause.

Local fix

  • Remove the NOT keyword in the expression (inside the Order By
    clause) to work around the problem.
    For example:
    changing : NOT ((T1.C1 IS NULL))
    into : ((T1.C1 IS NOT NULL))
    .

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 R910 users using CASE expressions *
    * in ORDER BY clause. *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E70005 in DSNXOEM:M310 *
    * for an SQL statement that satisfies the *
    * following conditions: *
    * 1. The statement contains a CASE *
    * expression which appears in the *
    * SELECT list and in the ORDER BY *
    * CLAUSE. *
    * 2. The CASE expression in the *
    * ORDER BY clause contains a NOT *
    * operation. *
    ****************************************************************
    * RECOMMENDATION: *
    ****************************************************************
    ABEND04E RC00E70005 in DSNXOEM:M310 for an SQL statement
    that contains a CASE expression in the SELECT list and
    in the ORDER BY clause. The CASE expression in the ORDER
    BY clause contains a NOT operation.

    For Example,

    SELECT (CASE WHEN (T1.C1 = 1) THEN 1 ELSE 2 END)
    FROM T1
    ORDER BY
    (CASE WHEN NOT (T1.C1 = 1) THEN 1 ELSE 2 END);

    The above statement causes an abend because the NOT operation
    in the CASE statement is not handle correctly.

Problem conclusion

  • DB2 was fixed to handle the CASE expression correctly.

    Additional Keywords: SQLCASE SQLORDERBY SQLNOT

Temporary fix

Comments

APAR Information

  • APAR number

    PK64568

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-16

  • Closed date

    2008-05-07

  • Last modified date

    2008-06-02

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

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

    UK36259

Modules/Macros
DSNXOEM          

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK36259

       UP08/05/27 P F805

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PK64568

Modified date:

2008-06-02

Translate my page

Machine Translation

Content navigation