SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

2-309

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.

\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 is unregistered is no longer visible on the target node. The

UNREGISTER CATALOG statement updates automatic catalog references to reflect

that.

A catalog cannot be unregistered if any of the following is true:



An object in the catalog is present on the target node, or depends on objects that

are present on the target node.



Definition schema tables for the catalog exist on the target node.

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]