PM11110: UNLOAD WITH PIC GENERATES INCORRECT OUTPUT DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unloads with PIC ('P' ) generate wrong output data for integer,
  decimal or float fields. When unloading a FLOAT or DECIMAL
  expression in external format (i.e. FORMAT DELIMITED, FORMAT
  EXTERNAL or CHAR/VARCHAR/DECIMAL EXTERNAL/FLOAT EXTERNAL
  specified as target format via a REFORMAT or an INTO clause)
  with a PIC option that specifies 'P' for the first subparameter,
  the sign byte for positive values is incorrect.
  - for FLOAT data, the sign byte is a binary zero (0x00)
    instead of the expected padding character;
  - for INTEGER and DECIMAL data, the sign byte is the leftmost
    digit of the value instead of the expected padding character.
  PB 10514
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of High Performance Unload.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unloads with PIC ('P'  ) generate       *
  *                      wrong output data for decimal or float  *
  *                      fields.  When unloading a FLOAT or      *
  *                      DECIMAL expression in external format   *
  *                      (i.e. FORMAT DELIMITED, FORMAT EXTERNAL *
  *                      or CHAR/VARCHAR/DECIMAL EXTERNAL/FLOAT  *
  *                      EXTERNAL specified as target format     *
  *                      via a REFORMAT or an INTO clause) with  *
  *                      a PIC option that specifies 'P' for     *
  *                      the first subparameter, the sign byte   *
  *                      for positive values is replaced with a  *
  *                      binary zero.                            *
  *                      PB 10514                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzatom, oatom, inzctrlf and inzctrlp   modules were changed to
  correctly take the PIC('P', ) specification into account.
  

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

•    INZRSAVE
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK56337

     UP10/04/29 P F004

• R320 PSY UK56338

     UP10/04/29 P F004

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.