PM11505: INCORRECT OUTPUT CONVERTING A NUMERIC COLUMN INTO A CHAR(30)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If FORMAT DELIMITED is requested, fields obtained through a
  conversion (via INTO clause or REFORMAT option) into a fixed
  length data type are unexpectedly written as variable length
  data.
  PB 10635
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: If FORMAT DELIMITED is requested,       *
  *                      fields obtained through a conversion    *
  *                      (via INTO clause or REFORMAT option)    *
  *                      into a fixed length data type are       *
  *                      unexpectedly written as variable length *
  *                      data.                                   *
  *                      PB 10635                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzctrlh  was changed to correctly determine the output
  field properties.
  

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

•    INZSIVP
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK56941

     UP10/05/20 P F005

• R320 PSY UK56942

     UP10/05/20 P F005

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.