PI80358: NON-DELIMITED SQL KEYWORDS NOT SUPPORTED AS COLUMN NAME IN DDLDDN FILE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload requesting the data from an image copy to be unloaded
  (COPYDDN option) and using the DDLDDN option to provide the
  unload with the DDL of a table that has at least one column
  which non-delimited name is an SQL keyword ends incorrectly.
  The error can be one of the following:
  - (incorrout) the unload ends with completion code 0 but does
     not unload the correct data
  - (abend) the unload ends in ABEND
  - (completion code 8) the unload unduly issues the INZI513E DDL
    ANALYSING: UNDEFINED COLUMN IN THE CREATE INDEX STATEMENT
    message and stops with completion code 8
  
  PB48921
  

Local fix

• In the file containing the DDL enclose any column name from the
  list mentioned above with double quotes'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload requesting the data from an   *
  *                      image copy to be unloaded (COPYDDN      *
  *                      option) and using the DDLDDN option to  *
  *                      provide the unload with the DDL of a    *
  *                      table that has at least one column      *
  *                      which non-delimited name is an SQL      *
  *                      keyword from the following list:        *
  *                                                              *
  *                        ACTION,ALL,ALWAYS,AS,ASC,ASCII,AT     *
  *                        ,ATTRIBUTES,AUDIT,BEGIN,BIGINT        *
  *                        ,BINARY,BIT,BLOB,BUSINESS,BY,CACHE    *
  *                        ,CAPTURE,CARDINALITY,CASCADE,CCSID    *
  *                        ,CHANGES,CHANGE,CHAR,CHARACTER        *
  *                        ,CHECK,CLOB,COLUMN,CONSTRAINT         *
  *                        ,CURRENT,CYCLE,DATABASE,DATA,DATE     *
  *                        ,DBCLOB,DECFLOAT,DEC,DECIMAL,DEFAULT  *
  *                        ,DEFAULTS,DEFERED,DEFINITION,DELETE   *
  *                        ,DESC,DISABLE,DOUBLE,DROP,EACH        *
  *                        ,EBCDIC,EDITPROC,ENABLE,END,ENDING    *
  *                        ,ENFORCED,EXCLUDING,EVERY,FIELDPROC   *
  *                        ,FLOAT,FOR,FOREIGN,G,GENERATED        *
  *                        ,GRAPHIC,ID,IDENTITY,IN,INCREMENT     *
  *                        ,INCLUDING,INCLUSIVE,INITIALLY,INT    *
  *                        ,INTEGER,K,KEY,LABEL,LARGE,LAST,LIKE  *
  *                        ,LONG,M,MAINTAINED,MAXVALUE,MINVALUE  *
  *                        ,MIXED,NO,NOCACHE,NOCYCLE,NOMAXVALUE  *
  *                        ,NOMINVALUE,NONE,NOORDER,NOT,NULL     *
  *                        ,NULLS,NUMERIC,OBID,OBJECT,ON,ONLY    *
  *                        ,OPTIMIZATION,ORDER,PART,PERIOD       *
  *                        ,PARTITION,PRECISION,PRIMARY,QUERY    *
  *                        ,RANGE,REAL,REFERENCES,REFRESH        *
  *                        ,RESTRICT,ROW,ROWID,SBCS,SECURITY     *
  *                        ,SET,SESSION,SIZE,SMALLINT,SQLID      *
  *                        ,START,SYSTEM,SYSTEM,TIME,TIMESTAMP   *
  *                        ,TRANSACTION,TYPE,UNICODE,UNIQUE      *
  *                        ,UPDATE,USER,USING,VALIDPROC,VALUES   *
  *                        ,VARBINARY,VARCHAR,VARGRAPHIC         *
  *                        ,VARYING,VOLATILE,WITH,WITHOUT,ZONE   *
  *                                                              *
  *                      ends incorrectly. The error can be one  *
  *                      of the following:                       *
  *                                                              *
  *                      - (incorrout) the unload ends with      *
  *                       completion code 0 but does not         *
  *                       unload the correct data                *
  *                                                              *
  *                      - (abend) the unload ends in ABEND      *
  *                                                              *
  *                      - (completion code 8) the unload        *
  *                       unduly issues the INZI513E DDL         *
  *                       ANALYSING: UNDEFINED COLUMN IN THE     *
  *                       CREATE INDEX STATEMENT message and     *
  *                       stops with completion code 8           *
  *                                                              *
  *                      pb 48921                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The INZSPUSQ  module ws 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:

  012AC3Ÿ PI83504 UI48427 UI48428

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI48427

     UP17/07/07 P F707

• R430 PSY UI48428

     UP17/07/07 P F707

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.