Adds a server to the ISYSSERVER table.
CREATE SERVER server-name CLASS 'server-class' USING 'connection-info' [ READ ONLY ] server-class: { ASAJDBC | ASEJDBC | SAODBC | ASEODBC | DB2ODBC | MSSODBC | ORAODBC | ODBC } connection-info: { machine-name:port-number [ /dbname ] | data-source-name }
If an ODBC-based server class is used, the USING clause is the data-source-name, which is the ODBC Data Source Name.
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.
SQL—ISO/ANSI SQL compliant.
Sybase—Supported by Open Client/Open Server.
Requires the SERVER OPERATOR system privilege.