Collection Contents Previous Next PDF

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_usernameidentifier

network-parametersstring

sync-typehttp | https | tcpip | ActiveSync

valuestring | 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 CommunicationAddress (adr) extended option.

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

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 
Standards and compatibility 

Collection Contents Previous Next PDF