During analysis of an RC/Compare strategy that is converting a CHARACTER type column into a DATE type column, message:
RMA231E ERROR OCCURED DURING GENERATION OF LOAD CONTROL CARDS FOR
WITH OLD NAME oldcolumnname AND NEW NAME newcolumnname
may be issued.
RC/Compare 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.
To generate the correct Load Control Card execute the following steps:
- Update the compare strategy,
- Explode the table
- Enter SRC in field CMD before the oldcolumname at CA - Table Alter screen
- 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.