In an Alter strategy, when adding a column the Default type (D column) can be 'C' for a CONSTANT. When this option is used it expects a value to be provided. How can a value be added for this constant?
Release : 20.0
Component : CA RC/Migrator for DB2 for z/OS
Please see the screens below for an example of how to add constant values.
At the bottom of the screen above, 'New_field' was added with a Default type of 'C' Constant.
Trying to exit the screen above (PF3) without specifying a Constant values shows this message:
Pressing PF1 displays Error Message Help:
To specify a constant enter 'E' or 'V' next to the column.
A 'V' will allow a longer value if needed. The value 12345 was added.
Using the 'E' option specify the value by 'DEFAULT VAL':
The following ALTER is generating after analyzing the strategy:
ALTER TABLE USER1.EMPTEST
ADD NEW_FIELD CHAR ( 5 )