|
SQL errors in replication must be designed out of your setup. SQL Remote includes an option to help you track errors in SQL statements, but this option is not intended to resolve such errors.
By setting the replication_error option, you can specify a stored procedure to be called by the Message Agent when a SQL error occurs. By default no procedure is called.
Issue the following statement:
SET OPTION remote-user.replication_error = 'procedure-name'
where remote-user is the user ID on the Message Agent command line and procedure-name is the procedure called when a SQL error is detected.
The replication error procedure must have a single argument of type 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.