Modifies the attributes of a remote server.
ALTER SERVER server-name
[ CLASS 'server-class' ]
[ USING 'connection-info' ]
[ CAPABILITY 'cap-name' { ON | OFF } ]
{ASAJDBC | ASEJDBC | ASAODBC | ASEODBC | DB2ODBC | MSSODBC | ORAODBC | ODBC }
{ machine-name:port-number [/dbname ] | data-source-name }
the name of a server capability
Change the server class of the Adaptive Server named ase_prod so its connection to Sybase IQ is ODBC-based. Its Data Source Name is ase_prod.
ALTER SERVER ase_prod CLASS 'ASEODBC' USING 'ase_prod'
Change a capability of server infodc:
ALTER SERVER infodc CAPABILITY 'insert select' OFF
The ALTER SERVER statement modifies the attributes of a server. These changes do not take effect until the next connection to the remote server.
CLASS clause The CLASS clause is specified to change the server class. For more information on server classes, see Chapter 17, “Server Classes for Remote Data Access” and Chapter 16, “Accessing Remote Data” in the Sybase IQ System Administration Guide.
USING clause The USING clause is specified to change the server's connection information. For more information about connection information, 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, Sybase IQ 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.
Automatic commit is a side effect of this statement.
Must have RESOURCE authority.
Chapter 17, “Server Classes for Remote Data Access” and Chapter 16, “Accessing Remote Data” in the Sybase IQ System Administration Guide
