PM27221: UNLOAD RC04 WITH NULLIF, CASE EXP, FASTUNLOAD DEFAULT IF, OR UNLOAD PLUS IF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload unduly ends with completion code 4 where an unload
  involves one of the following:
     - Native HPU syntax with SQL including one of the following
       expressions:
          + NULLIF( output-exp1, output-exp2)
          + CASE exp WHEN test-exp1 THEN output-exp1
                     WHEN test-exp2 THEN output-exp2
     - FASTUNLOAD syntax with DEFAULT IF( exp ) VALUE
         (output-value) clause
     - UNLOAD PLUS syntax with IF ... VALUE (output-value) clause
       and if the evaluation of the expression or clause output
       (named output-xxx above) requires conversion between either
       DATE, TIME or TIMESTAMP data and CHAR or VARCHAR data (both
       ways).
  Example: The issue occurs with the following unload
     UNLOAD SHRLEVEL CHANGE
     SELECT DATE_COLUMN
     INTO NULLDEFAULT_DATE_COLUMN  DATE IF NULL VALUE
     ('1900-01-01')
     FROM MY.TABLE
  since the char constant '1900-01-01' must be converted into a
  date type format.
  PB 10951
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 3.2 and HPU 4.1 only: The unload    *
  *                      unduly ends with completion code 4      *
  *                      where an unload involves one of the     *
  *                      following:                              *
  *                      - Native HPU syntax with SQL            *
  *                        including one of the following        *
  *                        expressions:                          *
  *                        + NULLIF( output-exp1, output-exp2)   *
  *                        + CASE exp WHEN test-exp1 THEN        *
  *                          output-exp1 WHEN test-exp2 THEN     *
  *                          output-exp2                         *
  *                      - FASTUNLOAD syntax with DEFAULT IF(    *
  *                        exp ) VALUE (output-value) clause     *
  *                      - UNLOAD PLUS syntax with IF ...        *
  *                        VALUE (output-value) clause           *
  *                      and if the evaluation of the expression *
  *                      or clause output (named output-xxx      *
  *                      above) requires conversion between      *
  *                      either DATE, TIME or TIMESTAMP data     *
  *                      and CHAR or VARCHAR data (both ways).   *
  *                      Example: The issue occurs with the      *
  *                      following unload                        *
  *                         UNLOAD SHRLEVEL CHANGE               *
  *                         SELECT DATE_COLUMN                   *
  *                         INTO NULLDEFAULT_DATE_COLUMN         *
  *                          DATE IF NULL VALUE('1900-01-01')    *
  *                         FROM MY.TABLE                        *
  *                      since the char constant '1900-01-01'    *
  *                      must be converted into a date type      *
  *                      format.                                 *
  *                      PB 10951                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inznode was fixed so that no warning completetion code is
  returned to the caller.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK63536

     UP11/01/05 P F101

• R410 PSY UK63537

     UP11/01/05 P F101

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.