USING Parameter in the CREATE SERVER Statement

You must run a separate CREATE SERVER statement for each remote database you intend to access.

For example, if a remote server named TestAA is running on the computer banana and owns three databases (db1, db2, db3), you would configure the local database server similar to this:

CREATE SERVER TestAAdb1
CLASS 'saodbc'
USING 'banana:2638/db1'
CREATE SERVER TestAAdb2
CLASS 'saodbc'
USING 'banana:2638/db2'
CREATE SERVER TestAAdb3
CLASS 'saodbc'
USING 'banana:2638/db3';

If you do not specify a /database-name value, the remote connection uses the remote database server's default database.