ASA SQL Reference
SQL Statements
Use this statement in an Adaptive Server Anywhere remote database to alter the properties of a subscription of a MobiLink user to a publication.
ALTER SYNCHRONIZATION SUBSCRIPTION
TO publication-name
[ FOR ml_username, ... ]
[ TYPE sync-type ]
[ ADDRESS network-parameters]
[ ADD OPTION option=value, ... ]
[ MODIFY OPTION option=value, ... ]
[ DELETE { ALL OPTION | OPTION option, ... } ]
ml_username: identifier
network-parameters: string
sync-type: http | https | tcpip | ActiveSync
value: string | integer
TO clause Specify the name of a publication.
FOR clause Specify one or more MobiLink user IDs.
Omit the FOR clause to set extended options, sync type and network parameters for a publication.
For information about how dbmlsync processes options that are specified in different locations, see Priority order for extended options and connection parameters.
TYPE clause This clause specifies the communication protocol to use for synchronization. The default protocol is tcpip.
ADDRESS clause This clause specifies network parameters, including the location of the MobiLink synchronization server.
For a complete list of network parameters, see CREATE SYNCHRONIZATION USER statement [MobiLink].
ADD OPTION, MODIFY OPTION, DELETE OPTION AND DELETE ALL OPTION clause These clauses allow you to add, modify, delete or delete all options. You may specify only one parameter in each clause.
The values for each option cannot contain the characters "=" or "," or ";".
For a complete list of options, see CREATE SYNCHRONIZATION USER statement [MobiLink].
Use this statement to alter a synchronization subscription within a MobiLink remote or reference database.
Must have DBA authority. Requires exclusive access to all tables referred to in the publication.
Automatic commit.
CREATE SYNCHRONIZATION USER statement [MobiLink]
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Create a default subscription, which contains default subscription values, for the sales publication (by omitting the FOR clause). Indicate the address of the MobiLink synchronization server and specify that only the Certicom root certificate is to be trusted.
CREATE SYNCHRONIZATION SUBSCRIPTION TO sales_publication ADDRESS 'host=test.internal;port=2439; security=ecc_tls' OPTION memory='2m';
Subscribe MobiLink user ml_user1 to the sales publication. Set the memory option to 3 Mb, rather than the value specified in the default publication.
CREATE SYNCHRONIZATION SUBSCRIPTION TO sales_publication FOR 'ml_user1' OPTION memory='3m';