USING parameter value in the CREATE SERVER statement

The USING parameter in the CREATE SERVER statement takes the form hostname:portnumber [/databasename], where:

hostname The machine that the remote server is running on

portnumber The TCP/IP port number that the remote server is listening on. The default port number that an Sybase IQ listens on is 2638.

databasename The Sybase IQ database that the connection will use. This is the name specified in the -n switch when the server was started, or in the DBN (DatabaseName) connection parameter.

Sybase IQ example

To configure Sybase IQ server named testiq that is located on the machine apple and listening on port number 2638, use:

CREATE SERVER testiq 
CLASS 'sajdbc' 
USING 'apple:2638'

See ”USING parameter in the CREATE SERVER statement” in SQL Anywhere Server - SQL Usage.