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

Document ID : KB000054116
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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
   TABLE: creator.tablename
   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.

Solution:

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 CA - 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.