RMA231E during CONVERT of a field within a RC/Compare strategy

Products

• RC Compare for DB2 for z/OS
• RC/Migrator for DB2 for z/OS

Issue/Introduction

During analysis of an RC/Compare for Db2 for z/OS (RCC) strategy that is converting a CHARACTER type column into a DATE type column, message:

RMA231E ERROR OCCURED DURING GENERATION OF LOAD CONTROL CARDS FOR
   TABLE: creator.tablename
   WITH OLD NAME oldcolumnname       AND NEW NAME newcolumnname

RCC is not able to generate the Load Control Cards due to the unsupported conversion.
This is issued when there has been no MASK specified to describe the format of the DATE in the CHARACTER column.

Resolution

To generate the correct Load Control Card execute the following steps:

1. Update the compare strategy,
2. Explode the table
3. Enter SRC in field CMD before the oldcolumname at Table Alter screen
4. At the panel "DATE Mask Specification" enter a mask that will describe the format of the DATE within the old non-DATE type column.
   This mask will be used to reformat the data to meet DATE column data restrictions.