PI94164: ENHANCEMENT AND FIXES OF THE DDL GENERATION FEATURE (LOADDDL TABLE OPTION OR CNTLCARDS_DB2(DDL) IN VUU030/ULOPTNS).

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This feature now supports the DB2 version 12 specific features
  below:
  - Column-definition: New CCSID-1208 and CCSID-1200 clause
  - Column-definition, generated-clause:
  New parameters special register, session variable, data change
  operation
  - Period-definition, option BUSINESS_TIME: new parameters
  exclusive and inclusive for the end column
  - PAGENUM option
  
  The following errors are fixed:
  - DATA CAPTURE option: Correction of syntax, typo in keyword.
  - Column-definition, data type TIMESTAMP: irrelevantly split
  into two lines.
  - Column-definition: new CCSID clause and existing
  FOR-MIXED-DATA clause unduly specified together.
  - Column-definition: columns implicitly generated by DB2 (for
  LOBS / XML) unduly specified in the generated DDL.
  
  PB50061  Z633 Z634
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancement and fixes of the DDL        *
  *                      generation feature (LOADDDL TABLE       *
  *                      option or CNTLCARDS_DB2(DDL) in         *
  *                      VUU030/ULOPTNS).                        *
  *                      This feature now supports the DB2       *
  *                      version 12 specific features below:     *
  *                      - Column-definition: New CCSID-1208     *
  *                       and CCSID-1200 clause                  *
  *                      - Column-definition, generated-clause:  *
  *                       New parameters special register,       *
  *                       session variable, data change          *
  *                       operation                              *
  *                      - Period-definition, option             *
  *                       BUSINESS_TIME: new parameters          *
  *                       exclusive and inclusive for the end    *
  *                       column                                 *
  *                      - PAGENUM option                        *
  *                      The following errors are fixed:         *
  *                      - DATA CAPTURE option: Correction of    *
  *                       syntax, typo in keyword.               *
  *                      - Column-definition, data type          *
  *                       TIMESTAMP: irrelevantly split into     *
  *                       two lines.                             *
  *                      - Column-definition: new CCSID clause   *
  *                       and existing FOR-MIXED-DATA clause     *
  *                       induly specified together.             *
  *                      - Column-definition: columns            *
  *                       implicitly generated by DB2 (for       *
  *                       LOBS / XML) unduly specified in the    *
  *                       generated DDL.                         *
  *                      pb50061                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzima, inzubi35 and inzups5 modules were changed.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI93908

• APAR is sysrouted TO one or more of the following:

  UI54072

Modules/Macros

•    INZTIMA  INZUBI35 INZUPS5  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI54072

     UP18/03/03 P F803

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.