Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : Multi-database query overview : The process of multi-database queries : 1. Defining the databases
 
1. Defining the databases
The databases to be queried consist of the primary database and auxiliary databases.
The primary database is the first database to which the client is connected. This is the database from which the OpenEdge SQL Server is generated. The catalog name of the primary database is the root name of the database. For example, in the database path /usr/databases/customer, the root name of the database is customer. Therefore, customer will be the catalog name of the primary database.
The auxiliary databases are the databases other than the primary database to which the client will connect in a multi-database environment.