Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Managing SQL Remote systems » Replication error reporting and handling


Ignoring replication errors

 Ignore replication errors (SQL)
  • Create a BEFORE trigger on the action that causes the known error. This trigger should signal an error.

    For example, if you want to ignore INSERT statement errors that occur when a table is missing a referenced column, create a BEFORE INSERT trigger that signals the SQLE_REMOTE_STATEMENT_FAILED SQLSTATE when the referenced column does not exist. The INSERT statement fails, but this failure is not reported in the SQL Remote Message Agent (dbremote) output log.

 See also