Adds a server to the ISYSSERVER table.
CREATE SERVER server-name CLASS 'server-class' USING 'connection-info' [ READ ONLY ]
CREATE SERVER ase_prod CLASS 'asejdbc' USING 'banana:3025'
CREATE SERVER testasa CLASS 'asajdbc' USING 'apple:2638'
CREATE SERVER oracle723 CLASS 'oraodbc' USING 'oracle723'
CREATE SERVER defines a remote server from the SAP Sybase IQ catalogs.
hostname—Is the machine on which the remote server runs.
portnumber—Is the TCP/IP port number on which the remote server listens. The default port number for SAP Sybase IQ and SQL Anywhere is 2638.
dbname—For SQL 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).
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.
SQL—ISO/ANSI SQL compliant.
Sybase—Supported by Open Client/Open Server.
Requires the SERVER OPERATOR system privilege.