Include the replicate SQLDML clause for a create table replication definition to support SQL statement replication.
This code segment displays the syntax for a create table replication definition:
[replicate {SQLDML [‘off’] | ‘options’}]
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
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.
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.