Create a BEFORE trigger on the action that causes the known error. This trigger should signal an error. For example, 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