Contents Index Server class asajdbc Server class asejdbc

ASA SQL User's Guide
  Server Classes for Remote Data Access
    JDBC-based server classes
      Server class asajdbc

USING parameter value in the CREATE SERVER statement

You must perform a separate CREATE SERVER for each Adaptive Server Anywhere database you intend to access. For example, if an Adaptive Server Anywhere server named testasa is running on the machine 'banana' and owns three databases (db1, db2, db3), you would configure the local Adaptive Server Anywhere similar to this:

CREATE SERVER testasadb1
CLASS 'asajdbc'
USING 'banana:2638/db1'
CREATE SERVER testasadb2
CLASS 'asajdbc'
USING 'banana:2638/db2'
CREATE SERVER testasadb2
CLASS 'asajdbc'
USING 'banana:2638/db3'

If you do not specify a /databasename value, the remote connection uses the remote Adaptive Server Anywhere default database.

For more information about the CREATE SERVER statement, see CREATE SERVER statement.


Contents Index Server class asajdbc Server class asejdbc