Sybase 12.4.2 manual Servers with multiple databases, 493

live_credit

CHAPTER 14 Adaptive Server IQ as a Data Server

Servers with multiple databases

Using Open Client Library, you can now connect to a specific database on a server with multiple databases.

•Set up entries in the interfaces file for each server.

•Use the -nparameter on the start_asiq command to set up a shortcut for the database name.

•Specify the -Sdatabase_name parameter with the database name on the isql command. This parameter is now required whenever you connect.

You can run the same program against multiple databases without changing the program itself by putting the shortcut name into the program and merely changing the shortcut definition.

For example, the following interfaces file excerpt defines two servers, live_credit and test_credit:

live_credit

query tcp ether host8832 5555 master tcp ether host 8832 5555

test_credit

query tcp ether host8832 7777 master tcp ether host 8832 7777

Start the server(s) and set up an alias for a particular database. The following command sets live_credit equivalent to creditcard.db:

start_asiq -n amxcredit_live <other parameters> \ -x ‘tcpip{port=5555}’ creditcard.db -n live_credit

To connect to the live_credit server, use this syntax:

isql -Udba -Psql -Slive_credit

A server name may only appear once in the interfaces file. Because the connection to Adaptive Server IQ is now based on the database name, the database name must be unique. If all your scripts are set up to work on creditcard database, you will not have to modify them to work with

or test_credit.

493