Show TOC

rs_autoc_offLocate this document in the navigation structure

Updates the rs_status table to indicate that autocorrection has been set to off.

Replication Server invokes rs_autoc_off when it encounters an autocorrection off record in the primary database log.
Examples
Example

Creates an rs_autoc_off function string for rs_iq_function_class.

create function string rs_autoc_off
 for rs_iq_function_class
 output language
  'update rs_status 
   set endtime = current timestamp, 
   status = "X" where schema = ?rs_repl_objowner!sys? 
   and tablename = ?rs_deliver_as_name!sys? 
   and action = "A" and endtime is null;
   insert into rs_status (schema, tablename, action, starttime, status) values 
   (?rs_repl_objowner!sys?, 
    ?rs_deliver_as_name!sys?, 
    "R", 
    current timestamp, 
    "P"); 
   commit'
Usage
  • The rs_autoc_off function has function-string-class scope.
  • Replication Server creates an initial rs_autoc_off function string during installation.
  • rs_autoc_off uses the <rs_deliver_as_name> system-defined variable, which indicates the table in the replicate database affected by autocorrection.
  • rs_autoc_off 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.