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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-50

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 volume named in the =_DEFAULTS define if no volume is specified).

If you do not specify a LOCATION clause and your system does not have a

value for the DDL_DEFAULT_LOCATIONS default (either in your environment

or at the system level) and your environment does not have a =_DEFAULTS

value, the CREATE statement will fail with an error.

See Schemas on page 6-101.

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]