Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Remote data access » Remote servers

 

Altering remote servers (SQL)

Administrators can alter the properties of a remote server in Interactive SQL.

Prerequisites

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.

 Alter the properties of a remote server

Changes to the remote server do not take effect until the next connection to the remote server.

  1. Connect to the host database.

  2. Execute an ALTER SERVER statement.

Results

The remote server properties are altered.

Example

The following statement changes the server class of the server named RemoteASE to ASEODBC.

ALTER SERVER RemoteASE
CLASS 'ASEODBC';

 See also