Adds a server to the sysservers table.
CREATE SERVER server-name CLASS 'server-class' USING 'connection-info' [ READ ONLY ]
{ ASAJDBC| ASEJDBC | ASAODBC | ASEODBC | DB2ODBC | MSSODBC | ORAODBC | ODBC}
{ machine-name:port-number [ /dbname ] | data-source-name }
Creates a remote server for the JDBC-based Adaptive Server named ase_prod. Its machine name is “banana” and port number is 3025.
CREATE SERVER ase_prod CLASS 'asejdbc' USING 'banana:3025'
Creates an Adaptive Server Anywhere remote server named testasa, located on the machine “apple,” and listening on port number 2638. Use:
CREATE SERVER testasa CLASS 'asajdbc' USING 'apple:2638'
Create a remote server for the Oracle server named oracle723. Its ODBC Data Source Name is “oracle723.”
CREATE SERVER oracle723 CLASS 'oraodbc' USING 'oracle723'
CREATE SERVER defines a remote server from the Sybase IQ catalogs.
For more information on server classes and how to configure a server, see Chapter 17, “Server Classes for Remote Data Access” in the Sybase IQ System Administration Guide.
USING clause If a JDBC-based server class is used, the USING clause is hostname:port-number [/dbname] where:
portnumber Is the TCP/IP port number on which the remote server listens. The default port number for Sybase IQ and Adaptive Server Anywhere is 2638.
dbname For Adaptive Server Anywhere remote servers, if you do not specify a dbname, the default database is used. For Adaptive Server Enterprise, the default is the master database, and an alternative to using dbname is to another database by some other means (for example, in the FORWARD TO statement).
For more information, see “JDBC-based server classes” in the Sybase IQ System Administration Guide.
If an ODBC-based server class is used, the USING clause is the data-source-name. The data-source-name is the ODBC Data Source Name.
READ ONLY The READ ONLY clause specifies that the remote server is a read-only data source. Any update request is rejected by Sybase IQ.
Automatic commit.
Must have RESOURCE authority.
