ml_passthrough

ml_passthrough_status

Stores the status for each passthrough script after it is executed by a client.

Column	Description
status_id	INTEGER. A unique integer that identifies the row.
remote_id	VARCHAR(128). Identifies the remote database that executed the script. References the remote_id in the ml_database table.
run_order	INTEGER. The run order of the script on the client.
script_id	INTEGER. Identifies the script that was executed. References the script_id in the ml_passthrough_script table.
script_status	CHAR(1). The status of the script. Contains S for success or E for error.
error_code	INTEGER. The SQL code generated by the script on the remote database.
error_text	TEXT. The error text generated by the script on the remote database.
remote_run_time	TIMESTAMP. The time at the remote database when the script was executed.

The MobiLink server does not automatically remove entries from the ml_passthrough_status table. Deletions from this table must be performed manually.

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

PRIMARY KEY( status_id )

FOREIGN KEY( remote_id ) REFERENCES ml_database( remote_id )

FOREIGN KEY( script_id) REFERENCES ml_passthrough_script( script_id )