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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-225

UNREGISTER CATALOG Statement

The UNREGISTER CATALOG statement removes an empty SQL/MX catalog

reference from a node.

catalog

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

not include any objects. No object in the catalog can be dependent on another

object.

\node

is the name of the target node, local or remote.

RESTRICT

specifies that only the reference for the named catalog will be removed. If that

catalog is related to other catalogs, an error occurs.

RESTRICT is the default.

CASCADE

specifies that the references for the named catalog, and any catalogs that are

directly or indirectly related to it, will be removed.

Considerations for UNREGISTER CATALOG

A catalog that has been unregistered is no longer visible on the target node.

UNREGISTER CATALOG updates automatic catalog references to reflect that.

Authorization and Availability Requirements

To remove the catalog reference, you must be the user who created the catalog or be

the super ID.

Example of UNREGISTER CATALOG

>> UNREGISTER CATALOG mycat FROM \nodex;

UNREGISTER CATALOG catalog FROM \node [RESTRICT | CASCADE]