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:

'manual;exclusive;schema_diff'

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 IBM 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 IBM 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:

DECLARE val INTEGER;
SELECT c1 INTO val FROM t1 WHERE pk = 5;
IF val > 100 THEN
    INSERT INTO t2 VALUES ('c1 is big');
ENDIF

Example of script content on an UltraLite remote:

CREATE TABLE myScript (c1 INT NOT NULL PRIMARY KEY)
GO
INSERT INTO myScript VALUES (1)
GO

description

VARCHAR(2000). A comment or description of the script. This value may be null.