Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : Multi-database query overview : The process of multi-database queries
 

The process of multi-database queries

A multi-database query is performed when a SELECT statement retrieves information from multiple databases simultaneously and the retrieved information is presented in a single result set. The process for performing this task is completed in the following order:
* 1. Defining the databases
* 2. Ensuring permissions to access databases to be queried
* 3. Connecting to the databases
* 4. Performing the query
* 5. Disconnecting