RESTRICT_ALT_COL_FOR_DCC in macro DSN6SPRM
Specifies whether restrictions apply to ALTER TABLE ALTER COLUMN statements for target tables that are defined with the DATA CAPTURE CHANGES attribute. Valid values are NO and YES.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| DSNZPxxx: | DSN6SPRM RESTRICT_ALT_COL_FOR_DCC |
| Security parameter: | No |
- NO
- Restrictions do not apply to altering column data types or default values of tables that are defined with the DATA CAPTURE CHANGES attribute. For such tables, ALTER TABLE ALTER COLUMN statements with the SET DATA TYPE, SET DEFAULT, or DROP DEFAULT options are allowed.
- YES
- restrictions apply to altering column data types or default values of tables that are defined with the DATA CAPTURE CHANGES attribute. ALTER TABLE ALTER COLUMN statements that are issued with the SET DATA TYPE, SET DEFAULT, or DROP DEFAULT options for such tables result in SQLCODE -148.