CREATE SERVER statement

Description

Adds a server to the sysservers table.

Syntax

CREATE SERVER server-name 
CLASS 'server-class' 
USING 'connection-info' 
[ READ ONLY ]

Parameters

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

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

Examples

Example 1

Create 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'
```
Create 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'
```

Usage

The CREATE SERVER statement 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 the hostname:port-number [/dbname] where:

hostname is the machine the remote server runs on

portnumber is the TCP/IP port number the remote server listens on. 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, then 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.

Side effects

Automatic commit.

Standards

SQL/92 Entry level feature.

Sybase Supported by Open Client/Open Server.

Permissions

Must have RESOURCE authority.

See also