PM81851: HPU NATIVE MODE SQL EXPRESSION DATE(CHAR_DATA) WHERE CHAR_DATA IS A NON CONSTANT CHAR TYPE DATA IS INCORRECTLY EVALUATED

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When processed in native mode, an SQL expression DATE(char_data)
    where char_data is a non constant char type data is incorrectly
    evaluated which leads to the following issues:
    - if the DATE(char_data) expression is part of the output
    columns, an evaluation error is reported by issuing
    messages such as "227 * EXPRESSION EVALUATION ERROR"
    and no rows are unloaded
    - if the DATE(char_data) expression is part of a
    predicate used in a WHERE clause the number of output
    rows is incorrect and usually equals to zero.
    PB11815
    

Local fix

  • Use the DB2 FORCE option to run the unload in SQL mode
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 High Performance Unload.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: When processed in native mode, an SQL   *
    *                      expression DATE(char_data) where        *
    *                      char_data is a non constant char type   *
    *                      data is incorrectly evaluated which     *
    *                      leads to the following issues:          *
    *                      - if the DATE(char_data) expression is  *
    *                       part of the output columns, an         *
    *                       evaluation error is reported by        *
    *                       issuing messages such as "227 *        *
    *                       EXPRESSION EVALUATION ERROR" and no    *
    *                       rows are unloaded                      *
    *                      - if the DATE(char_data) expression is  *
    *                      part of a predicate used in a WHERE     *
    *                      clause the number of output rows is     *
    *                      incorrect and usually equals to zero.   *
    *                      pb 11815                                *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    The inznode, inznodeh and udbspgsq modules were fixed.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM81851

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-31

  • Closed date

    2013-05-07

  • Last modified date

    2013-06-04

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

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

Modules/Macros

  •    INZCHECK INZSIVP
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R410 PSY UK94106

       UP13/05/14 P F305

  • R420 PSY UK94107

       UP13/05/14 P F305

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 Tools for z/OS
DB2 High Performance Unload

Software version:

4.1.0

Reference #:

PM81851

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation