Table Replication Definition

Include the replicate SQLDML clause for a create table replication definition to support SQL statement replication.

Syntax

This code segment displays the syntax for a create table replication definition:

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

Parameters

‘options’ – a combination of these statements:
- U – update
- D – delete
- I – insert select

Examples

Example 1 – 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

Usage

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.