PH31228: DDL/GEN OF TABLE WITH NON-ROWID COLUMN SYSCOLUMNS DEFAULT 'A' EXECUTING DDL RESULTS IN SQLCODE = -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL/GEN produces the GENERATED ALWAYS clause for table
  columns if the SYSCOLUMNS value for DEFAULT=A,
  regardless of the column type.  If the column type is not ROWID,
  however, the DDL is invalid, and an attempt to execute it will
  result in the following error (for example):
  
  
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "BLOB". SOME
  SYMBOLS THAT MIGHT BE LEGAL ARE:  ROWID
  DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNHSM5 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = 5 0 13 -1 716 502 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'00000005' X'00000000' X'0000000D'
  X'FFFFFFFF'
  X'000002CC' X'000001F6' SQL DIAGNOSTIC INFORMATION
  
  
  KEYWORD:  SQLCODE104N
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS reverse engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN produces GENERATED ALWAYS columns   *
  *                      for some LOB columns, and executing the *
  *                      DDL may result in a SQLCODE = -104      *
  *                      error.                                  *
  ****************************************************************
  In cases where the SYSCOLUMNS entry for a table column has a
  COLTYPE value of CLOB, BLOB, or DBCLOB and a DEFAULT value of A,
  GEN produces a GENERATED ALWAYS column. For example:
  
  BLOB(2 G) NOT NULL GENERATED ALWAYS
  
  Creating a table with such a column definition will result in
  SQLCODE -104.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI74041

Modules/Macros

• ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74041

     UP21/02/23 P F102

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.