ml_delete_passthrough system procedure

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.

Syntax
ml_delete_passthrough ( 
'remote_id', 
'script_name', 
'run_order' 
)
Parameters

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.

Remarks

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.

See also