Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

ALTER STATISTICS statement Next Page

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]


Use this statement in a SQL 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 network-protocol ]
[ ADDRESS protocol-options ]
[ ADD OPTION option=value, ... ]
[ ALTER OPTION option=value, ... ]
[ DELETE { ALL OPTION | OPTION option, ... } ]

ml_username: identifier

network-protocol: http | https | tls |tcpip

protocol-options: string

value: string | integer

Parameters

TO clause    Specify the name of a publication.

FOR clause    Specify one or more MobiLink user names.

Omit the FOR clause to set the protocol type, protocol options, and extended options for a publication.

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

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

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 may specify only one option in each clause.

The values for each option cannot contain the characters "=" or "," or ";".

For a complete list of options, see MobiLink SQL Anywhere Client Extended Options.

Remarks

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.

Permissions

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

Side effects

Automatic commit.

See also
Standards and compatibility
Example

The following example changes the address of the MobiLink server:

ALTER SYNCHRONIZATION SUBSCRIPTION
TO p1
FOR ml1
TYPE TCPIP
ADDRESS 'host=10.11.12.132;port=2439';