ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

ALTER SYNCHRONIZATION SUBSCRIPTION
{ subscription-name | TO publication-name [ FOR ml-username, ...  ] }

alter-clause:
RENAME new-subscription-name
| TYPE network-protocol
| ADDRESS protocol-options
| ADD OPTION option=value, ... 
| ALTER OPTION option=value, ...
| DELETE { ALL OPTION | OPTION option, ... } 
| SET SCRIPT VERSION=script-version

subscription-name: identifier

publication-name: identifier

ml-username: identifier

new-subscription-name: identifier

network-protocol: http | https | tls | tcpip

protocol-options: string

value: string | integer

option: identifier

script-version: string

TO clause This clause specifies the name of a publication.
If the TO clause is used without a FOR clause, you cannot use the RENAME or SET SCRIPT VERSION clauses.
FOR clause This clause specifies one or more MobiLink user names.
Omit the FOR clause to set the protocol type, protocol options, and extended options for a publication.

If the TO clause is used without a FOR clause, you cannot use the RENAME or SET SCRIPT VERSION clauses.

For information about how dbmlsync processes options that are specified in different locations, see Priority order.
RENAME clause This clause specifies a new name for the subscription.
If the TO clause is used without a FOR clause, you cannot use the RENAME clause.
TYPE clause This clause specifies the network protocol to use for synchronization. The default protocol is tcpip.
For more information about communication protocols, see CommunicationType (ctp) extended option.
ADDRESS clause This clause specifies network protocol options, including the location of the MobiLink server.
For a complete list of protocol options, see MobiLink client network protocol option summary.
ADD OPTION, ALTER OPTION, DELETE OPTION, and DELETE ALL OPTION clauses These clauses allow you to add, alter, delete, or delete all extended options. You can specify only one option in each clause. No option is specified for Delete All.
The values for each option cannot contain the characters " = " or " , " or " ; ".

For a complete list of options, see MobiLink SQL Anywhere client extended options.
SET SCRIPT VERSION clause This clause specifies the script version to use during synchronization. You can alter the script version without making a schema change.
If the TO clause is used without a FOR clause, you cannot use the SET SCRIPT VERSION clause.

For more information about MobiLink script versions, see Script versions.

The network-protocol, protocol-options, and options can be set in several places.

For information about how dbmlsync processes options that are specified in different locations, see Priority order.

This statement causes options and other information to be stored in the SQL Anywhere ISYSSYNC system table. Anyone with DBA authority for the database can view the information, which could include passwords and encryption certificates. To avoid this potential security issue, you can specify the information on the dbmlsync command line. See dbmlsync syntax.

DBA authority and exclusive access to all tables referred to in the publication.

Automatic commit.

CREATE PUBLICATION statement [MobiLink] [SQL Remote]
DROP PUBLICATION statement [MobiLink] [SQL Remote]
SQL Anywhere MobiLink clients: Creating synchronization subscriptions
UltraLite MobiLink clients: Designing synchronization in UltraLite
ISYSSYNC system table

SQL/2008 Vendor extension.

The following example changes the address of the MobiLink server for the sales subscription:

ALTER SYNCHRONIZATION SUBSCRIPTION sales
TYPE TCPIP
ADDRESS 'host=10.11.12.132;port=2439';

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Syntax

Parameters

Remarks

Permissions

Side effects

See also

Standards and compatibility

Example