Use this system procedure to create a passthrough script. This procedure adds an entry to the ml_passthrough_script system table.
ml_add_passthrough_script ( 'script_name', 'flags', 'affected_pubs', 'script', 'description' )
Syntax |
Description |
||||
---|---|---|---|---|---|
script_name |
VARCHAR(128). The script name. This value must be unique. |
||||
flags |
VARCHAR(256). The value that tells clients how to run the script. This value can be null or contain a combination of the following keywords in a semicolon-delimited list:
For example:
|
||||
affected_pubs |
TEXT. A list of publications that must be synchronized before the script is run. An empty string or null indicates that no synchronization is required. This value is only meaningful for SQL Anywhere clients. For Adaptive Server Enterprise, this parameter is VARCHAR(16384). For DB2 LUW, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB. |
||||
script |
TEXT. The contents of the passthrough script. This value cannot be null. For Adaptive Server Enterprise, this parameter is VARCHAR(16384). For DB2 LUW, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB. The script content must be non-null. For UltraLite remotes, the script content should be a collection of SQL statements separated by the word go. Note that the word go must appear on a separate line. For SQL Anywhere remotes, the script content can be any collection of SQL statements that are valid when enclosed by a begin…end block. Example of script content on a SQL Anywhere remote:
Example of script content on an UltraLite remote:
|
||||
description |
VARCHAR(2000). A comment or description of the script. This value may be null. |
This procedure generates an error if the specified script_name already exists in ml_passthrough_script.
For DB2 mainframe consolidated database types, this procedure is called ml_add_pt_script. 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 |