Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : Connecting to multiple databases : Using the CONNECT AS CATALOG statement
 

Using the CONNECT AS CATALOG statement

Use the CONNECT AS CATALOG statement to connect to an auxiliary database.
The CONNECT AS CATALOG statement uses the following syntax:
CONNECT ‘database_path' AS CATALOG catalog_name;
In the following example, the database named customer in directory /usr/databases is connected as a catalog named ‘mydb1'.
CONNECT 'usr/databsaes/customer' AS CATALOG mydb1;
For more information on the CONNECT AS CATALOG statement, see OpenEdge Data Management: SQL Reference.