Example

This example creates a replication definition named titles_repdef for the TITLES table. The primary copy of the TITLES table is located on the MVSA data server, in the DSNA DB2 subsystem. All replicate copies of the table are named TITLES. All columns in the TITLES table are replicated.

The case of the table and column names you specify in your replication definition must exactly match the case of the DB2 source table and column names.

create replication definition titles_repdef
 with primary at MVSA.DSNA
 with all tables named 'TITLES'
 (
 TITLE_ID char(6),
 TITLE varchar(80),
 TYPE char(12),
 PUBDATE datetime,
 PRICE float
 )
 primary key (TITLE_ID)