PI52079: UNEXPECTED PADDING OF THE NULL VALUE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When the NULLVAL option of the FORMAT DELIMITED or
  FORMAT XML is specified, the content of the fields for the NULL
  values is incorrect if the following applies:
  
  - the related column of the target table to be
    unloaded has a variable data type
  - a reformatting request into a fixed length
    external data type applies to the column
  
  such as in the example below.
  
  UNLOAD TABLESPACE
  OPTIONS REFORMAT (TYPE VARCHAR INTO VARCHAR LENGTH MAX)
  DB2 NO
  SELECT MY_VARCHAR_COLUMN, 'END'
  FROM ME.MYTABLE
  OUTDDN (SYSREC)
  FORMAT DELIMITED SEP ';' NULLVAL ''
  
  PB12900
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The content of the fields for the NULL  *
  *                      values is incorrect for target columns  *
  *                      for which a reformatting request into   *
  *                      a fixed length data type applies such   *
  *                      as in the example below.                *
  *                      UNLOAD TABLESPACE                       *
  *                      OPTIONS REFORMAT (TYPE VARCHAR INTO     *
  *                       VARCHAR LENGTH MAX)                    *
  *                      DB2 NO                                  *
  *                      SELECT MY_VARCHAR_COLUMN, 'END'         *
  *                      FROM ME.MYTABLE                         *
  *                      OUTDDN (SYSREC)                         *
  *                      FORMAT DELIMITED SEP ';' NULLVAL ''     *
  *                      which gives an output such as           *
  *                      0jsFcGhY  /END    <--                   *
  *                      MY_VARCHAR_COLUMN is not NULL           *
  *                                /END    <--                   *
  *                      MY_VARCHAR_COLUMN is NULL               *
  *                      while the following output is expected  *
  *                      0jsFcGhY  /END    <--                   *
  *                      MY_VARCHAR_COLUMN is not NULL           *
  *                      /END              <--                   *
  *                      MY_VARCHAR_COLUMN is not NULL           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The udbcrfel module was changed.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

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

• R430 PSY UI32343

     UP15/11/28 P F511

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.