PK68431: INZU015E AFTER MIGRATION TO HPU R310

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In Fastunload syntax, a SELECT that contains a UNION or UNION
    ALL is incorrectly rejected with the following error message:
    INZU015E SELECT STATEMENT MUST BE TERMINATED BY A SEMI-COLON.
    PB 9476
    ADDITIONAL SYMPTOMS
    1. When the padding character is defined with an empty string,
       an error message INZI006E NO CONVERSION WAS AVAILABLE BETWEEN
       CCSID 253 AND CCSID 37 is issued.
       Module inzhyacc was changed to ignore the padding character
       when it is an empty string.
       PB 9579
    2) MSG INZT034E when unloading a LOB with &UNIQ variable.
    INZT034E TEMPLATE ERROR: TEMPLATE OUTLOB REDEFINES DSNAME
       dsname(memname)
       PREVIOUSLY GENERATED FROM TEMPLATE OUTLOB
       INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x12da003)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 High Performance Unload.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following is for 220 and 310:       *
    *                      1. Character constants that appear in a *
    *                      SELECT processed with FORMAT DELIMITED  *
    *                      are not surrounded by the delimited     *
    *                      character when the SELECT is processed  *
    *                      natively. PB 9436                       *
    *                                                              *
    *                      The following is for 310 only:          *
    *                      2. In Fastunload syntax, a SELECT that  *
    *                      contains a UNION or UNION ALL is        *
    *                      incorrectly rejected with the           *
    *                      following error message: INZU015E       *
    *                      SELECT STATEMENT MUST BE TERMINATED BY  *
    *                      A SEMI-COLON. The same syntax is        *
    *                      accepted by HPU 220. PB 9476            *
    *                      3. Error message INZC018E UNBALANCED    *
    *                      QUOTE occurs when a dsname is coded     *
    *                      between quotes in a TEMPLATE, and with  *
    *                      a last qualifier coded on exactly 2     *
    *                      characters or with a last qualifier     *
    *                      coded on one character when this        *
    *                      character is N, G, X or C. PB 9495      *
    *                      4. Error message INZU238E UNEXPECTED    *
    *                      UNSUPPORTED SELECT occurs when a        *
    *                      conversion of a numeric field to a      *
    *                      DECIMAL EXTERNAL(3) or DECIMAL(1). The  *
    *                      problem occurs when the number of       *
    *                      significant digits is 1. PB 9562        *
    *                      5. DEC(DAY(coldate)) incorrectly        *
    *                      returns a decimal field with an         *
    *                      invalid precision. The expected         *
    *                      precision is DEC(11). PB 9563           *
    *                      6. In UNLOAD PLUS syntax, when the      *
    *                      INTO clause contains a IF NULL on a     *
    *                      decimal column and when the VALUE does  *
    *                      not match the field definition, error   *
    *                      message INZU238E UNEXPECTED             *
    *                      UNSUPPORTED SELECT is issued. PB 9564   *
    *                      7. An abend S0C4 occurs when a SELECT   *
    *                      without OUTDDN is specified in SYSIN.   *
    *                      The expected behavior is a RC=8 with    *
    *                      error message NZU096E REQUIRED KEYWORD, *
    *                      OUTDDN, NOT SPECIFIED, PROCESSING       *
    *                      TERMINATED. PB 9565                     *
    *                      8. When a VARCHAR scalar function is    *
    *                      applied on a DECIMAL expression, the    *
    *                      result returned by HPU is incorrect,    *
    *                      truncation may occur on the output      *
    *                      varchar. PB 9569                        *
    *                      9. An abend S0C4 may occur when a non   *
    *                      supported expression on constants is    *
    *                      coded in a SELECT. Example of non       *
    *                      supported expression:                   *
    *                      DECIMAL(1234 , 5 , 2 )                  *
    *                      Correct behavior is to issue error      *
    *                      message INZU025E INVALID OPERAND FOR    *
    *                      OPERATOR operator. PB 9574              *
    *                      10. An abend S0C1 can occur when        *
    *                      converting a CHAR constant into a       *
    *                      SMALLINT, using either a FORMAT USER    *
    *                      or an INTO clause. PB 9575              *
    *                      11. In FastUnload syntax, an unload     *
    *                      made in OUTPUT-FORMAT FIXED or          *
    *                      EXTERNAL that selects constants and     *
    *                      reformat them with an INTO clause into  *
    *                      a DECIMAL value gives an incorrect      *
    *                      result. PB 9576                         *
    *                      12. When the padding character is       *
    *                      defined with an empty string, an error  *
    *                      message INZI006E NO CONVERSION WAS      *
    *                      AVAILABLE BETWEEN CCSID 253 AND CCSID   *
    *                      37 is issued. PB 9579                   *
    *                      13. In FastUnload syntax, the           *
    *                      following conversion: INTO DECIMAL(5,2) *
    *                      NOTNULL DEFAULTIF ( C3 IS NULL)         *
    *                      INITIAL ( 1.5 ) generates the           *
    *                      following error message: INZU238E       *
    *                      UNEXPECTED UNSUPPORTED SELECT. PB 9580  *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    1. Module inzctrl, function inzcontrolCheckEcsConstant was
    changed to set the delimiter when character constants are
    selected.
    2. Module inzfyacc was changed to accept the complete SELECT
    when it contains some UNION keywords.
    3. Module inztyacc was changed to avoid this problem.
    4. Module UDBSPGSQ was changed to accept conversion into a
    decimal with a single significant digit.
    5. Module inznode was changed to generate the correct field.
    6. Module inznode was changed to accet IF NULL with conversions.
    7. Module inznode was changed to issue the appropriate error
    message.
    8. Module UDBSPGSQ was changed to process correctly this
    conversion.
    9. Module inznode, function inznodeFlagOprCst was changed to
    issue the appropriate error message and avoid the abend.
    10. Module inzctrl, function inzcontrolCheckTypes was changed
    to fix the conversion CHAR into SMALLINT.
    11. Module Inznode was changed to do the correct conversion.
    12. Module inzhyacc was changed to ignore the padding character
    when it is an empty string.
    13. Module Inznode was changed to accept the described
    conversion.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK68431

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-01

  • Closed date

    2008-09-15

  • Last modified date

    2008-10-24

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

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

    UK39910 UK39911

Modules/Macros

  • INZUTILB INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R220 PSY UK39910

       UP08/09/24 P F809

  • R310 PSY UK39911

       UP08/09/24 P F809

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:

3.1.0

Reference #:

PK68431

Modified date:

2008-10-24

Translate my page

Machine Translation

Content navigation