When Source and Destination Columns Have Different Names

When you want only one replication definition for a source table, and the source column names differ from their destination counterparts, use the column_name as replicate_column_name clause in the replication definition.

For example, for a source table named publishers1 and a destination table named publishers2, where the source column pub1_name corresponds to the destination column pub2_name, enter this:

create replication definition publishers_rep
with primary at TOKYO_DS.pubs2
with primary table named publishers1
with replicate table named publishers2
(pub_id char(4),
pub1_name as pub2_name varchar(40),
city varchar(20),
state char(2))
primary key (pub_id)