Create a BEFORE trigger on the action that causes the known error. This trigger should signal the REMOTE_STATEMENT_FAILED SQLSTATE (5RW09) or SQLCODE (-288) value.
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 REMOTE_STATEMENT_FAILED SQLSTATE when the referenced column does not exist. The INSERT statement fails, but this failure is not reported in the Message Agent (dbremote) output log. See Remote statement failed.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|