SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

2-77

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-3.

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

define value, the CREATE statement will fail with an error.

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 and Availability Requirements

The users who are granted the privilege using GRANT CREATE CATALOG can create

a catalog. If such users are not specified, any user can execute this statement.

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