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.