Show TOC

rs_autoc_ignoreLocate this document in the navigation structure

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.