The SQL passthrough feature is extremely powerful and must be used with caution. It is particularly important that scripts be well tested because SQL passthrough script errors can potentially disable or damage all of your remotes. Avoid errors with thorough testing.
When a SQL passthrough script on the client generates errors, the errors must be resolved at the consolidated database or the client is not able to run any more SQL passthrough scripts.
The -vo server option for mlsrv11 can be used to capture SQL passthrough activity on the MobiLink server that can help you resolve errors. See -v option.
The primary mechanism for resolving an error on a client is to add a row to the ml_passthrough_repair table using the ml_add_passthrough_repair system procedure. Rows in the ml_passthrough_repair table describe the action the client should take when a specific script generates a specific error code.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|