PK68431: INZU015E AFTER MIGRATION TO HPU R310

Obtain the fix for this APAR.

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 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.