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:

  • Log the error in a separate table.
  • Instruct the MobiLink server whether to ignore the error and continue, or rollback the synchronization, or rollback the synchronization and shut down the MobiLink server.
  • Send an email message.

For more information, see handle_error connection event.

Reporting errors
Handling multiple errors in a single SQL statement

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0