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.