Download IBM Informix Dynamic Server Enterprise Replication Guide

Conflict Resolution
Important: The owner of an SPL routine used for conflict resolution must be the
same as the owner of the table.
Routines for conflict-resolution must be in SPL. Enterprise Replication does
not allow user-defined routines in C or in Java.
Important: You cannot use an SPL routine or a time stamp with an SPL routine if
the replicate is defined to replicate only changed columns or the replicated table
contains any extensible data types. See “Replicating Only Changed Columns” on
page 6-11.
Enterprise Replication passes the following information to an SPL routine as
arguments.
Argument
Description
Server name [CHAR(18)]
From the local target row
NULL if local target row does not exist
Time stamp (DATETIME YEAR TO SECOND)
From the local target row
NULL if local target row does not exist
Local delete-table indicator [CHAR(1)]
■
Y indicates the origin of the row is the delete table
or
■
K indicates the origin of the row is the replicate-key
delete row (for a key update that is sent as a key delete
and a key insert) because the local target row with the
old key does not exist
Local key delete-row indicator [CHAR(1)]
Server name [CHAR(18)]
Of the replicate source
Time stamp (DATETIME YEAR TO SECOND) From the replicated row
Replicate action type [CHAR(1)]
I- insert
D- delete
U- update
Local row data returned in regular SQL format Where the regular SQL format is taken from the SELECT
clause of the participant list
Replicate row data after-image returned in
regular SQL format
Where the regular SQL format is taken from the SELECT
clause of the participant list
Selecting the Enterprise Replication System and Network Topology 3-15