rs_autoc_ignore

Updates the rs_status table to indicate that autocorrection has failed and that DML is ignored for a table.

Replication Server invokes rs_autoc_ignore when a primary-key update is made during autocorrection.

Examples

Example –

Creates an rs_autoc_ignore function string for rs_iq_function_class.

create function string rs_autoc_ignore
 for rs_iq_function_class
 output language
  'update rs_status 
   set endtime = current timestamp, 
   status = 'E' where schema = ?rs_repl_objowner!sys? 
   and tablename = ?rs_deliver_as_name!sys? 
   and action = 'A' and endtime is null; 
   commit'

Usage

The rs_autoc_ignore function has function-string-class scope.
Replication Server creates an initial rs_autoc_ignore function string during installation.
rs_autoc_ignore uses the rs_deliver_as_name system-defined variable, which indicates the table in the replicate database affected by autocorrection.
rs_autoc_ignore uses the rs_repl_objowner system-defined variable, which indicates the owner of the table in the replicate database affected by autocorrection. If no owner is specified, rs_repl_objowner contains a single space.