ASA SQL Reference
  SQL Statements

CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Description 

Use this statement in an Adaptive Server Anywhere remote database to subscribe a MobiLink user to a publication.

Syntax 

CREATE SYNCHRONIZATION SUBSCRIPTION
TO publication-name
[ FOR ml_username, ...  ]
[ TYPE sync-type ]
[ ADDRESS network-parameters]
[ OPTION option=value, ... ]

ml_username: identifier

network-parameters: string

sync-type: http | https | tcpip | ActiveSync

value: string | integer

Parameters 

TO clause    Specify the name of a publication.

FOR clause    Specify one or more MobiLink user names. ml_username is a name identifying a remote database. This name must be unique.

For more information about synchronization user names, see About MobiLink users.

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

OPTION clause    This clause allows you to set extended options for the subscription. If no FOR clause is provided, the extended options act as default settings for the publication, and are overridden by any extended options set for a synchronization user.

For a complete list of options, see -e extended options.

Usage 

Use this statement to create 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 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

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