Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSSUBSCRIPTION system view Next Page

SYSSYNC system view


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.

Columns
Column name Column type Column constraint
sync_id UNSIGNED INT NOT NULL
type CHAR(1) NOT NULL
publication_id UNSIGNED INT
progress UNSIGNED BIGINT
site_name CHAR(128)
"option" LONG VARCHAR
server_connect LONG VARCHAR
server_conn_type LONG VARCHAR
last_download_time TIMESTAMP
last_upload_time TIMESTAMP NOT NULL
created UNSIGNED BIGINT
log_sent UNSIGNED BIGINT
generation_number INTEGER NOT NULL
extended_state VARCHAR(1024) NOT NULL

sync_id    A number that uniquely identifies the row.

type    The type of synchronization object: D means definition, T means template, and S means site.

publication_id    A publication_id found in the SYSPUBLICATION system view.

progress    The log offset of the last successful upload.

site_name    A MobiLink user name.

"option"    Synchronization options.

server_connect    The address or URL of the MobiLink server.

server_conn_type    The communication protocol, such as TCP/IP, to use when synchronizing.

last_download_time    Indicates the last time a download stream was received from the MobiLink server.

last_upload_time    Indicates the last time (measured at the MobiLink server) that information was successfully uploaded. The default is jan-1-1990.

created    The log offset at which the subscription was created.

log_sent    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    For file-base downloads, the last generation number received for this subscription. The default is 0.

extended_state    Reserved for internal use.

Constraints on underlying system table

PRIMARY KEY (sync_id)

FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)

UNIQUE (publication_id, site_name)