SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-164

The REGISTER CATALOG statement registers an SQL/MX catalog on a remote node.

A catalog is not visible to a remote node until you register it.

catalog

is the ANSI name of the target catalog. It must be visible on the local node. No

catalog with the same name can exist on the target node. You cannot register the

system catalog.

\node.$volume

is the remote node on which the catalog will be registered.

RESTRICT

specifies that only the named catalog is registered. If that catalog is related to other

catalogs, an error occurs.

RESTRICT is the default.

CASCADE

specifies that the named catalog, and any catalogs that are directly or indirectly

related to it, will be registered.

Considerations for REGISTER CATALOG

updates automatic catalog references. If a catalog reference already exists on the

target node with a different volume name and no definition schemas exist on that node

for that catalog, NonStop SQL/MX changes the volume name to volume.

Authorization and Availability Requirements

To register a catalog, you must be the user who created the catalog or be the super ID.

A transaction can be user-initiated or system-initiated. If no transaction exists,

NonStop SQL/MX automatically starts one.

Examples of REGISTER CATALOG

•

This command registers a catalog on another node:

CASCADE]