ASA SQL Reference
  SQL Statements

ALTER SERVER statement

Description 

Use this statement to modify the attributes of a remote server.

Syntax 

ALTER SERVER server-name
[ CLASS 'server-class' ]
[ USING 'connection-info' ]
[ CAPABILITY 'cap-name' { ON | OFF } ]

server-class :
  ASAJDBC | ASEJDBC
| ASAODBC | ASEODBC
| DB2ODBC | MSSODBC
| ORAODBC | ODBC

connection-info :
machine-name:port-number[/dbname ] | data-source-name

Parameters 

CLASS clause    The CLASS clause is specified to change the server class.

For more information on server classes and how to configure a server, see Server Classes for Remote Data Access.

USING clause    The USING clause is specified to change the server connection information. For information about connection-info, see CREATE SERVER statement.

CAPABILITY clause    The CAPABILITY clause turns a server capability ON or OFF. Server capabilities are stored in the system table syscapability. The names of these capabilities are stored in the system table syscapabilityname. The syscapability table contains no entries for a remote server until the first connection is made to that server. At the first connection, Adaptive Server Anywhere interrogates the server about its capabilities and then populates the syscapability table. For subsequent connections, the server's capabilities are obtained from this table.

In general, you do not need to alter a server's capabilities. It may be necessary to alter capabilities of a generic server of class ODBC.

Usage 

The ALTER SERVER statement modifies the attributes of a server. These changes do not take effect until the next connection to the remote server.

Permissions 

Must have RESOURCE authority.

Side effects 

Automatic commit.

See also 

CREATE SERVER statement

DROP SERVER statement

Server Classes for Remote Data Access

Troubleshooting remote data access

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Open Client/Open Server.

Example 

The following example changes the server class of the Adaptive Server named ase_prod so its connection to Adaptive Server Anywhere is ODBC-based. Its Data Source Name is ase_prod.

ALTER SERVER ase_prod
CLASS 'ASEODBC'
USING 'ase_prod'

• The following example changes a capability of server infodc.

ALTER SERVER infodc
CAPABILITY 'insert select' OFF