Administrators can alter the properties of a remote server in Interactive SQL.
Prerequisites
DBA authority.
Context and remarks
The ALTER SERVER statement can also be used to enable or disable a server's known capabilities.
Alter the properties of a remote serverChanges to the remote server do not take effect until the next connection to the remote server.
Connect to the host database.
Execute an ALTER SERVER statement.
Exemple
The following statement changes the server class of the server named RemoteASE to aseodbc. In this example, the Data Source Name for the server is RemoteASE.
ALTER SERVER RemoteASE CLASS 'aseodbc'; |
See also |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |