Try OpenEdge Now
skip to main content
SQL Development
Performing Multi-database Queries : Connecting to multiple databases : Specifying a database default catalog : Using the SET CATALOG statement
 
Using the SET CATALOG statement
Use the SET CATALOG statement to change the default catalog name to be used for schema, table, and column references.
The SET CATALOG statement uses the following syntax:
SET CATALOG catalog_name ;
The following example shows how the auxiliary database connection is identified by the catalog named mydb1.
SET CATALOG mydb1;
For more information on the SET CATALOG statement, see OpenEdge Data Management: SQL Reference.