LI74274: DB2LOOK WITH OPTION -TD DELIMITER DOES NOT GENERATE SPECIFIED DELIMITER FOR USER-DEFINED TYPES.

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When specified -td option to generate delimiter other than
  defalult Semicolon (;), it just ignore specified delimiter.
  
  db2look -d test -e -td @ > db2look1.out
  
  vi db2look1.out
  
  =============
  
  CREATE TYPE "xxxxxx "."TYPEARRAY" AS VARCHAR(50) ARRAY[50];
  
  Note : statement ends with a semi-colon, not with @ delimiter.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * SOFTWARE                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * db2look was not considering -td option for create type DDL   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * move to v95 fp5                                              *
  ****************************************************************
  

Problem conclusion

• fixed in v95 fp5
  

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:

  LI74275

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSY

     UP