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 SQL Reference.