Table Replication Definition

To support SQL statement replication, you must include the replicate SQLDML clause when you create a table replication definition.

The syntax for create replication definition must include the clause:

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

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

U – update
D – delete
I – insert select

Note: If your replication definition has the [replicate {minimal | all} columns] clause, then the [replicate {minimal | all} columns] clause must always precede the [replicate {SQLDML [‘off’] | ‘options’}] clause.

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.