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

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Alters the properties of a synchronization subscription in a SQL Anywhere remote database.

Syntax
ALTER SYNCHRONIZATION SUBSCRIPTION
{ subscription-name | TO publication-name [ FOR ml-username, ...  ] } { alter-clause ... }
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 | NULL
protocol-options : string | NULL
value : string | integer
option : identifier
script-version : string | NULL
Parameters
  • 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.

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

  • ADDRESS clause

    This clause specifies network protocol options, including the location of the MobiLink server.

  • 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 " ; ".

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

Remarks

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

This statement causes options and other information to be stored in the SQL Anywhere ISYSSYNC system table. Depending on the privileges a user has, they may be able to 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.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

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