Use this statement in a SQL Anywhere remote database to alter the properties of a MobiLink user.
ALTER SYNCHRONIZATION USER 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
TYPE clause This clause specifies the network protocol to use for synchronization.
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, modify, delete, or delete all extended options. You may specify only one option in each clause.
For a complete list of options, see MobiLink SQL Anywhere client extended options.
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 about the dbmlsync command line.
See dbmlsync syntax.
Must have DBA authority. Requires exclusive access to all tables referred to in the publication.
Automatic commit.
SQL/2003 Vendor extension.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |