Each row in the SYSSYNCSCRIPT system view identifies a stored procedure for MobiLink scripted upload. This view is almost identical to the SYSSYNCSCRIPTS view, except that the values in this view are in their raw format. To see them in their human-readable format, see SYSSYNCSCRIPTS consolidated view.
For information about which publications use scripted upload, see SYSPUBLICATION system view.
For information about stored procedure definitions, see SYSPROCEDURE system view.
The underlying system table for this view is ISYSSYNCSCRIPT.
Column name | Column type | Description |
---|---|---|
pub_object_id | UNSIGNED BIGINT | The object ID of the publication to which the script belongs. |
table_object_id | UNSIGNED BIGINT | The object ID of the table to which the script applies. |
type | UNSIGNED INT | The type of upload procedure. |
proc_object_id | UNSIGNED BIGINT | The object ID of the stored procedure to use for the publication. |
PRIMARY KEY (pub_object_id, table_object_id, type)
FOREIGN KEY (pub_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (table_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (proc_object_id) references SYS.ISYSOBJECT (object_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |