Contents Index ALTER SERVICE statement ALTER SYNCHRONIZATION USER statement [MobiLink]

ASA SQL Reference
  SQL Statements

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]


Description 

Use this statement in an Adaptive Server Anywhere remote database to alter the properties of a subscription of a MobiLink user to a publication.

Syntax 

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_usernameidentifier

network-parametersstring

sync-typehttp | https | tcpip | ActiveSync

valuestring | integer

Parameters 

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].

Usage 

Use this statement to alter a synchronization subscription within a MobiLink remote or reference database.

Permissions 

Must have DBA authority. Requires exclusive access to all tables referred to in the publication.

Side effects 

Automatic commit.

See also 

CREATE PUBLICATION statement

CREATE SYNCHRONIZATION USER statement [MobiLink]

Standards and compatibility 
Examples 

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';

Contents Index ALTER SERVICE statement ALTER SYNCHRONIZATION USER statement [MobiLink]