This stored procedure removes the row(s) in the ml_passthrough table that cause the specified script to be downloaded to the specified remote with the specified run order. If the script is downloaded to the remote before it is deleted then it is not deleted from the remote and executes as usual.
ml_delete_passthrough ( 'remote_id', 'script_name', 'run_order' )
Syntax |
Description |
---|---|
remote_id |
VARCHAR(128). The remote ID. If remote_id is null then all rows in the ml_passthrough table for the specified script name and run order are removed. |
script_name |
VARCHAR(128). The script name. |
run_order |
INTEGER. The run order of the script applied on the remote database. If run_order is null then all rows for the specified remote_id and script_name are removed from the ml_passthrough table regardless of their run order. |
The MobiLink server does not automatically remove entries from the ml_passthrough table. You must use this procedure to remove outdated passthrough scripts.
For DB2 mainframe consolidated database types, this procedure is called ml_del_pt. See IBM DB2 mainframe system procedure name conversions.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |