PM70803: CREATE TABLE WITH SPACE IN QUALIFIER AND A LOB COLUMN GETS -204

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• create table with space in qualifier and a lob column gets -204
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of CREATE TABLE     *
  *                 statement.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE -204 can be returned for a   *
  *                      CREATE TABLE statement with LOB         *
  *                      columns.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a table schema contains trailing blanks, and CURRENT RULES =
  STD, users may receive SQLCODE204 on CREATE TABLE defined with a
  LOB column when DB2 tries to implicitly create the auxiliary
  objects and does not recognize the table schema.
  

Problem conclusion

• The code in DB2 has been fixed to create table (with a LOB
  column) successfully when CURRENT RULES = STD is specified and
  the schema contains trailing blanks.
  
  Additional Keywords:
  SQLCREATE
  DB2LOB
  SQLLOB
  

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:

  UK83493

Modules/Macros

•    DSNXICDR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK83493

     UP12/11/29 P F211

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.