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

book

Article ID: 210459

calendar_today

Updated On:

Products

CA RC/Migrator for DB2 for z/OS

Issue/Introduction

 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?

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

Resolution

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   
        '12345'                                    
            ;                  

Attachments