Introduction to SQL passthrough

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:

Create a script and store it in the consolidated database. See Creating a script and ml_add_passthrough_script system procedure.
Create one or more passthrough entries for the script which identify the clients that should execute it. See Creating passthrough entries and ml_add_passthrough system procedure.
Download the script. See Downloading scripts and ml_add_passthrough system procedure.
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.

Creating a script
Creating passthrough entries
Downloading scripts
Executing scripts
Capturing script results
Reviewing script results
Handling script errors

Send feedback about this page via email or DocCommentXchange