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

SQL Anywhere 10.0.1 » MobiLink - Server Administration » Writing Synchronization Scripts

Writing download_delete_cursor scripts Next Page

Writing scripts to handle errors

An error in a synchronization script occurs when an operation in the script fails while the MobiLink server is executing it. The DBMS returns a SQLCODE to the MobiLink server indicating the nature of the error. Each consolidated database DBMS has its own set of SQLCODE values.

When an error occurs, the MobiLink server invokes the handle_error event. You should provide a connection script associated with this event to handle errors. The MobiLink 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.

Error handling actions

Some actions you may want to take in an error-handling script are:

For more information, see handle_error connection event.

Reporting errors
Handling multiple errors in a single SQL statement