ml_passthrough

Stores rows that indicate which scripts should run on each remote database.

Column

Description

remote_id

VARCHAR(128). The remote ID of the client that should execute the script.

run_order

INTEGER. The run order of the script for this client. This value must be non-negative.

script_id

INTEGER. An integer that references the script_id in the ml_passthrough_script table. This value identifies the script to be executed.

last_modified

TIMESTAMP. The last time the passthrough information was added or modified.

Remarks

You can use the system procedures ml_add_passthrough and ml_delete_passthrough to add, modify, and delete entries in this table.

For DB2 mainframe consolidated database types, this table is called ml_pt. See IBM DB2 mainframe system table name conversions.

Constraints

PRIMARY KEY( remote_id, run_order )

FOREIGN KEY( remote_id ) REFERENCES ml_database( remote_id )

FOREIGN KEY( script_id ) REFERENCES ml_passthrough_script( script_id )

See also