SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-52

CREATE CATALOG Statement

Considerations for CREATE CATALOG

Examples of CREATE CATALOG

The CREATE CATALOG statement creates a new SQL/MX catalog. See Catalogs on

page 6-2.

CREATE CATALOG is an SQL/MX extension.

Syntax Description of CREATE CATALOG

catalog

is an SQL identifier that specifies the name of the new catalog. catalog must be

unique among catalog names on the node.

LOCATION [\node].$volume

specifies the location of the metadata tables for the catalog.

node

is the name of the local node.

volume

is the name of an audited, non-SMF DAM volume on the specified node (or the

Guardian system named in the =_DEFAULTS define if no volume is specified).

See Schemas on page 6-104.

Considerations for CREATE CATALOG

Reserved Catalogs

Catalog names beginning with NONSTOP_SQLMX_ are reserved for system

metadata. You are not allowed to create (or to drop) catalogs with these reserved

names.

Authorization Requirements

Any user on a node can create a catalog on the node.

CREATE CATALOG catalog [LOCATION [\node.]$volume]