PI83502: TRIM OPTION AND TRIM SCALAR FUNCTION: CHAR/VARCHAR FOR BIT DATA DATA NOT TRIMMED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The TRIM option and the TRIM sclar function unduly have no
  effect (the data is not trimmed) on a column defined as CHAR or
  VARCHAR with the FOR BIT DATA attribute.
  
  PB48959
  

Local fix

• Consider using the TRIM function and run the unload in SQL mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the High Performance Unload product                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI80530: The TRIM option and the TRIM sclar function unduly  *
  * have no effect (the data is not trimmed) on a column defined *
  * as CHAR or VARCHAR with the FOR BIT DATA attribute.          *
  *                                                              *
  * PI80358: 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,BIG *
  * INT,BINARY,BIT,BLOB,BUSINESS,BY,CACHE,CAPTURE,CARDINALITY,CA *
  * SCADE,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,E *
  * NFORCED,EXCLUDING,EVERY,FIELDPROC,FLOAT,FOR,FOREIGN,G,GENERA *
  * TED,GRAPHIC,ID,IDENTITY,IN,INCREMENT,INCLUDING,INCLUSIVE,INI *
  * TIALLY,INT,INTEGER,K,KEY,LABEL,LARGE,LAST,LIKE,LONG,M,MAINTA *
  * INED,MAXVALUE,MINVALUE,MIXED,NO,NOCACHE,NOCYCLE,NOMAXVALUE,N *
  * OMINVALUE,NONE,NOORDER,NOT,NULL,NULLS,NUMERIC,OBID,OBJECT,ON *
  * ,ONLY,OPTIMIZATION,ORDER,PART,PERIOD,PARTITION,PRECISION,PRI *
  * MARY,QUERY,RANGE,REAL,REFERENCES,REFRESH,RESTRICT,ROW,ROWID, *
  * SBCS,SECURITY,SET,SESSION,SIZE,SMALLINT,SQLID,START,SYSTEM,S *
  * YSTEM,TIME,TIMESTAMP,TRANSACTION,TYPE,UNICODE,UNIQUE,UPDATE, *
  * USER,USING,VALIDPROC,VALUES,VARBINARY,VARCHAR,VARGRAPHIC,VAR *
  * YING,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           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF                                                *
  ****************************************************************
  Code to fix this problem has been changed.
  

Problem conclusion

• Apply the PTF
  

Temporary fix

• PI80530: Consider using the TRIM function and run the unload in
  SQL mode.
  PI80358: In the file containing the DDL enclose any column name
  from the list mentioned above with delimiters
  

Comments

APAR Information

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

  PI80530

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

  UI48487

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI48487

     UP17/07/11 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.