Administrators can alter the properties of a remote server in Interactive SQL.
You must have the SERVER OPERATOR system privilege.
Context and remarks
The ALTER SERVER statement can also be used to enable or disable a server's known capabilities.
Changes 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.
The following statement changes the server class of the server named RemoteASE to ASEODBC.
ALTER SERVER RemoteASE CLASS 'ASEODBC';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|