Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : An example of a multi-database query : Connecting to an auxiliary database
 

Connecting to an auxiliary database

A client is connected to a general ledger database and would like to connect to the accounts payable database. The accounts payable database exists in the directory called /usr/data/accounting. The client executes the following statement:
CONNECT ‘/usr/data/accounting/apdb' AS CATALOG actpay;