RCM: How to specify a CONSTANT value when adding a column in an Alter Strategy


Article ID: 210459


Updated On:


CA RC/Migrator for DB2 for z/OS


 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 )                   
                        WITH DEFAULT