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

SQL Anywhere 12.0.0 (Français) » SQL Remote » Managing SQL Remote systems » Reporting and handling replication errors

 

Run an error-handling procedure

Set the replication_error option to call a procedure when a SQL error occurs. By default, no procedure is called when a SQL error occurs.

The procedure that is called must have a single argument type of CHAR, VARCHAR, or LONG VARCHAR. The procedure is called once with the SQL error message and once with the SQL statement that causes the error. See replication_error option [SQL Remote].

 ♦  To set the replication_error option
  • Execute the following statement. The remote-user is the publisher name on the SQL Remote Message Agent (dbremote) command and procedure-name is the procedure called when a SQL error is detected.

    SET OPTION
    remote-user.replication_error
    = 'procedure-name';

Collect errors from the remote database
Receive email notification about remote database errors