PK07219: SQLCODE104 ON SMART ALTER ALC APPENDING COLUMN WITH USER DEFINED DEFAULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool an ALC smart alter operation to
  append a new column defined as NOT NULL with a user defined
  default can fail with sqlcode104 ( -104 ).
  .
  The default value appears with an extra set of quote marks as
  shown in the following:
      SQL ALTER TABLE "C717086"."TBDAIRY" ADD "ADDED_COL" CHAR(1)
  NOT NULL WITH DEFAULT ''D'';
  .
  Execution produces error messages similar to the following:
  .
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "D". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: FOR NOT WITH UPDATE DEFAULT
     FIELDPROC GENERATED CONSTRAINT
  .
  Additional symptoms: extra quotes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who         *
  *                 use ALC may be affected.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE104 may occur due to a double-   *
  *                      -quoted value during ALC processing     *
  *                      when adding a new column to the end     *
  *                      of the table, and specifying a default  *
  *                      value for the column.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE104 occurred on SMART ALTER ALC appending column with
  user defined default.
  

Problem conclusion

• The product did not determine if the value was already quoted.
  The reported problem has now been corrected.
  

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:

Modules/Macros

•    ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK05401

     UP05/07/26 P F507

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.