In the Data Replication Console, you can edit existing virtual columns.
On the
Map Tables
tab, select the mapped source table to which you previously added the virtual column that you want to edit.
Click the
Show Virtual Columns
icon button above the source tables filter field, or right-click the source table row and click
Show Virtual Columns
.
The
Virtual Columns for <table_name>
dialog box appears.
Select the virtual column that you want to edit and click
Edit
.
The
Add virtual column
dialog box appears.
Enter changes in one or more fields.
The availability of some fields depends on the datatype.
If you change the datatype of a mapped virtual column, Data Replication validates that the virtual column and target column have compatible datatypes. If the datatypes are not compatible, the Data Replication Console displays an error message that prompts you to map the virtual column to a target column that has a compatible datatype.
Click
OK
.
Data Replication applies the changes. If the replication configuration contains multiple virtual columns that have the same column name, datatype, expression, and properties (precision, scale, and size), Data Replication applies the changes to all of these virtual columns.