Altering remote servers

Use the 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.

Example

The following statement changes the server class of the server named ASEserver to aseodbc:

ALTER SERVER ASEserver 
CLASS 'aseodbc' 

The Data Source Name for the server is ASEserver.

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

For a complete description of the ALTER SERVER statement, see Sybase IQ Reference Manual.