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.
Refer to the SYSPUBLICATION system view for information about which publications use scripted upload, and refer to the SYSPROCEDURE system view for the stored procedure definitions.
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)
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |