ASA SQL Reference
  SQL Statements

ALTER SYNCHRONIZATION USER statement [MobiLink]

Description 

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

Syntax 

ALTER SYNCHRONIZATION USER ml_username
[ TYPE sync-type ]
[ ADDRESS network-parameters ]
[ ADD OPTION option=value, ... ]
[ MODIFY OPTION option=value, ... ]
[ DELETE { ALL OPTION | OPTION option } ]

ml_username: identifier

network-parameters: string

sync-type: http | https | tcpip | ActiveSync

value: string | integer

Parameters 

TYPE clause    This clause specifies the communication protocol to use for synchronization.

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.

For a complete list of options, see CREATE SYNCHRONIZATION USER statement [MobiLink].

Usage 

Use this statement to alter the properties of a synchronization user within a MobiLink remote database.

Permissions 

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

Side effects 

Automatic commit.

See also 

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

CREATE SYNCHRONIZATION USER statement [MobiLink]

CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.