The SQL Passthrough feature allows you to download scripts of SQL statements from a consolidated database to a SQL Anywhere or UltraLite client, and have those SQL statements executed on the client at an appropriate time. The scripts are numbered and are guaranteed to be executed on the client in order.
After a script is executed or an attempt is made to execute it, status is sent back to the consolidated database with the next synchronization so that both successful runs and failures can be centrally monitored. When an error occurs executing a script on a client, no further scripts are executed on that client until the status has been uploaded to the consolidated database and the consolidated has downloaded instructions to the client on how to proceed. These instructions may mean retrying the existing script, skipping it, or downloading a new script to fix the error.
Below is an overview of the steps required to use SQL Passthrough:
Execute the script. See Executing scripts.
Capture the results. See Capturing script results.
Review the results. See Reviewing script results.
Handle errors, if necessary. See Handling script errors.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|