SYSSYNC system table
1038
SYSSYNC system table
Column name Column type
Column
constraint
Table
constraints
sync_id SMALLINT NOT NULL Primary key
type CHAR(1) NOT NULL
publication_id SMALLINT
progress NUMERIC(20,0)
site_name CHAR(128)
option LONG VARCHAR
server_connect LONG VARCHAR
server_conn_type LONG VARCHAR
last_download_time TIMESTAMP
This table contains information relating to MobiLink synchronization.
sync_id A SMALLINT field uniquely identifying the row.
type A CHAR(1) field describing the type of synchronization object:
’D ’ m ea ns d e f ini t i o n, ’T ’ means t e mpla t e, and ’S ’ mea ns sit e .
publication_id A
publication_id
found in the SYSPUBLICATIONS table.
progress A SMALL INT field that indicates the status.
site_name A CHAR(128) field that holds a MobiLink user id.
option A LONG VARCHAR that holds any synchronization options.
progress A SMALL INT field that indicates the status.
server_connect A LONG VARCHAR field that holds the address or
URL of the MobiLink synchronization server.
server_conn_type A LONG VARCHAR field identifying the
communication protocol, such as TCP/IP, to use when synchronizing.
last_download_time A TIMESTAMP field that indicates the last time a
download stream was received from the MobiLink synchronization server..