Altering remote servers (SQL)

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

Prérequis

You must have the SERVER OPERATOR system privilege.

Contexte et remarques

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.

Résultat

The remote server properties are altered.

Exemple

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

ALTER SERVER RemoteASE
CLASS 'ASEODBC';