Table replication definition

To support SQL statement replication, you must include the replicate SQLDML clause for a create table replication definition. This code segment displays the syntax for a create table replication definition:

[replicate {SQLDML [‘off’] | ‘options’}]

The ‘options’ parameter is a combination of these statements:

• U – update

• D – delete

• I – insert select

This is a sample create replication definition for a table:

create replication definition repdef1
       with primary at ds3.pdb1
       with all tables named 'tb1'
       
           (id_col int,
           str_col char(40))
       
       primary key (id_col)
       replicate all columns
       replicate ‘UD’
go

A table replication definition with the send standby clause can specify a replicate ‘I’ statement. You can replicate an insert select statement as a SQL replication statement only in warm standby or MSA environments. A table replication definition without a send standby clause cannot replicate the insert select statement.