ml_add_passthrough_repair system procedure

Use this system procedure to define rules for handling script errors. Each rule defines the action that a client should perform when a specific script generates a given error code. This procedure adds an entry to the ml_passthrough_repair system table. If an entry with the given failed_script_name and error_code already exists in the table, the procedure updates the entry.

Syntax
ml_add_passthrough_repair ( 
'failed_script_name', 
error_code, 
'new_script_name', 
'action' 
)
Parameters

Syntax

Description

failed_script_name

VARCHAR(128). The name of the failed script to which this rule applies. This value must be a valid script name in the ml_passthrough_script table.

error_code

INTEGER. The SQL Anywhere error code that this rule handles.

new_script_name

VARCHAR(128). The name of a script to replace the failed script when action is R. If action is S, P, or H, this value must be null. If action is R, this value must be a valid script name in the ml_passthrough_script table, and can be the same as failed_script_name.

action

CHAR(1). The action that a client should perform when error_code is generated for failed_script_name. This value must be one of the following:

  • R   (replace) Indicates that the failed script should be replaced with the one specified by new script name and an attempt should be made to run the new script. To rerun the failed script, choose new script name to be the same as failed script name.

  • P   (purge) Indicates that the remote database should discard all the scripts that it has received and continue executing script normally after that.

  • S   (skip) Indicates that the remote database should ignore the failed script and continue executing scripts as if the failed script had succeeded.

  • H   (halt) Indicates that the remote should not execute any more scripts until it receives further instructions.

Remarks

You should make every effort to avoid failed SQL passthrough scripts by testing scripts thoroughly.

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

See also