Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : Connecting to multiple databases
 

Connecting to multiple databases

Connections to multiple databases may be made using one of two methods, either the use of SQL commands or the employment of a properties file that defines the connections.
* Connecting to multiple databases using SQL commands
* Specifying a database default catalog
* Determining catalog availability
* Using the CONNECT AS CATALOG statement
* Disconnecting from catalogs
* Using the DISCONNECT CATALOG statement
* Using properties files to enable multiple database connections