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

Obtain the fix for this APAR.

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 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 I 1000

• R420 PSY UK94107

     UP13/05/14 I 1000

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.