IBM Data Lifecycle - Integration and Governance Connect with experts and peers to elevate technical expertise, solve problems and share insights. Join / Log in
Im trying to create a column map from VARCHAR(128) to VARCHAR(128) data type using TRANS COL. There is no problem until I try to input TRANS COL with copy parameter. From the documentation it is said that "The copy= parameter is valid only for a character data type column", so I assume this can be used to CHAR and VARCHAR data type column. The command is TRANS COL ('UNIQUE,COPY=(1,4)'), when i save the column map there is an error shown in the image bellow. Ive tried to other columns, both varchar and char, and the results are the same. If I remove the COPY or change the parameter, it works as expected, e.g. TRANS COL ('UNIQUE') or TRANS COL ('UNIQUE,SEED=RANDOM'). What do I need to fix/change in order to use TRANS COL with copy parameter?Env: Infosphere Optim 11.7 Test Data Management & Data Privacy - Windows server 2019Thank you for your assistance.