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

Specifying a database default catalog

The database catalog to be used for queries when the catalog is not given in a schema, table, or column specification is the primary database catalog unless the default is changed. The default catalog may be changed using the Progress Software Corporation specific SQL statement SET CATALOG.
Note: When you connect to auxiliary databases using a previously used pooled connection, you will inherit the database configurations as set by the previous user.
* Using the SET CATALOG statement