PI77202: INVALID DATE EXTERNAL(4) IN GENERATED LOAD STATEMENT IF REFORMAT/INTO CLAUSE INTO DATE DATA TYPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A LOAD statement (LOADDDN option) containing an invalid DATE
  EXTERNAL(4) specification is generated whenever all the
  following conditions apply:
  -  the target table has a date type column
  -  a conversion from a date expression into a DATE format is
     requested via an INTO or a REFORMAT clause
  -  the DSNTIAUL format is request
  As the conversion into a DATE type request implies the date
  column to be unload in internal format, the data cannot be
  reload by the IBM load utility and no valid LOAD statement can
  be generated.
  
  PB48339
  

Local fix

• if the data must be reloaded by the IBM LOAD utility, either do
  no request the conversion from date type columns into DATE or
  request a conversion into DATE EXTERNAL so that the date is
  unloaded in external format. If the internal date format is
  expected, remove the LOADDDN option as this prevent the data to
  be loaded by the IBM LOAD utility.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A LOAD statement (LOADDDN option)       *
  *                      containing an invalid DATE EXTERNAL(4)  *
  *                      specification is generated whenever all *
  *                      the following conditions apply:         *
  *                      - the target table has a date type      *
  *                       column                                 *
  *                      - a conversion from a date expression   *
  *                       into a DATE format is requested via    *
  *                       an INTO or a REFORMAT clause           *
  *                      - the DSNTIAUL format is request        *
  *                      As the conversion into a DATE type      *
  *                      request implies the date column to be   *
  *                      unload in internal format, the data     *
  *                      cannot be reload by the IBM load        *
  *                      utility and no valid LOAD statement     *
  *                      can be generated.                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload and inzmsgs 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:

  UI46841

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI46841

     UP17/05/05 P F705

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.