PI57958: THE REFORMAT (TYPE TIMESTAMP INTO TIMESTAMP_X) OPTION HAS NO EFFECT AND OUTPUT FORMAT OF THE TIMESTAMP IS DEFAULT ONE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The REFORMAT (TYPE TIMESTAMP INTO TIMESTAMP_x) option, where
  TIMESTAMP_x stands for one of the TIMESTAMP_A, TIMESTAMP_B ....,
  TIMESTAMP_G timestamp format, has no effect. The output format
  of the timestamp is default one whatever the TIMESTAMP_x target
  requested.
  
  PB44559
  

Local fix

• Use OPTIONS TIMESTAMP TIMESTAMP_X that gives the expected
  result.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The REFORMAT (TYPE TIMESTAMP INTO       *
  *                      TIMESTAMP_x) option, where              *
  *                      TIMESTAMP_x stands for one of the       *
  *                      TIMESTAMP_A, TIMESTAMP_B ....,          *
  *                      TIMESTAMP_G timestamp format, has no    *
  *                      effect if FORMAT DELIMITED is           *
  *                      requested. The output format of the     *
  *                      timestamp is default one whatever the   *
  *                      TIMESTAMP_x target requested.           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzhyacc and inzctrlh  modules were changed.
  

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

• R420 PSY UI37984

     UP16/05/24 P F605

• R430 PSY UI37985

     UP16/05/24 P F605

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.