The SYSSYNC system view contains information relating to MobiLink synchronization. Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority. The SYSSYNC2 view provides public access to the data in this view except for the potentially sensitive columns. The underlying system table for this view is ISYSSYNC.
|Column name||Column type||Description|
|sync_id||UNSIGNED INT||A number that uniquely identifies the row.|
|type||CHAR(1)||The type of synchronization object: D means definition, T means template, and S means site.|
|publication_id||UNSIGNED INT||A publication_id found in the SYSPUBLICATION system view.|
|progress||UNSIGNED BIGINT||The log offset of the last successful upload.|
|site_name||CHAR(128)||A MobiLink user name.|
|"option"||LONG VARCHAR||Synchronization options.|
|server_connect||LONG VARCHAR||The address or URL of the MobiLink server.|
|server_conn_type||LONG VARCHAR||The communication protocol, such as TCP/IP, to use when synchronizing.|
|last_download_time||TIMESTAMP||Indicates the last time a download stream was received from the MobiLink server.|
|last_upload_time||TIMESTAMP||Indicates the last time (measured at the MobiLink server) that information was successfully uploaded. The default is jan-1-1900.|
|created||UNSIGNED BIGINT||The log offset at which the subscription was created.|
|log_sent||UNSIGNED BIGINT||The log progress up to which information has been uploaded. It is not necessary that an acknowledgement of the upload be received for the entry in this column to be updated.|
|generation_number||INTEGER||For file-base downloads, the last generation number received for this subscription. The default is 0.|
|extended_state||VARCHAR(1024)||For internal use only.|
PRIMARY KEY (sync_id)
FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|