ASA SQL User's Guide
  Accessing Remote Data
    Working with remote servers

Altering remote servers

You can use Sybase Central or an ALTER SERVER statement to modify the attributes of a server. These changes do not take effect until the next connection to the remote server.

You must have RESOURCE authority to alter a server.

To alter the properties of a remote server (Sybase Central)

1. Connect to the host database from Sybase Central.

2. Open the Remote Servers folder for that database.

3. Right-click the remote server and choose Properties from the popup menu.

4. Configure the various remote server properties.

To alter the properties of a remote server (SQL)

1. Connect to the host database from Interactive SQL.

2. Execute an ALTER SERVER statement.

Example 

The following statement changes the server class of the server named ASEserver to aseodbc. In this example, the Data Source Name for the server is ASEserver.

ALTER SERVER ASEserver
CLASS 'aseodbc'

The ALTER SERVER statement can also be used to enable or disable a server's known capabilities.

For more information, see ALTER SERVER statement.