MobiLink Synchronization User's Guide
Writing Synchronization Scripts
An error in a synchronization script occurs when an operation in the script fails while the MobiLink synchronization server is executing it. The DBMS returns a SQLCODE to the MobiLink synchronization server indicating the nature of the error. Each consolidated database DBMS has its own set of SQLCODE values.
When an error occurs, the MobiLink synchronization server invokes the handle_error event. You should provide a connection script associated with this event to handle errors. The MobiLink synchronization server passes several parameters to this script to provide information about the nature and context of the error, and requires an output value to tell it how to respond to the error.
Some actions you may wish to take in an error-handling script are:
Log the error in a separate table.
Instruct the MobiLink synchronization server whether to ignore the error and continue, or rollback the synchronization, or rollback the synchronization and shut down the MobiLink synchronization server.
Send an e-mail message.
For more information, see handle_error connection event.
Reporting errors
Handling multiple errors on a single SQL statement