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

SQL/MX Language Elements

HP NonStop SQL/MX Reference Manual—540440-003

6-2

Catalogs

SQL/MX Catalogs

An SQL/MX catalog is a named logical object that contains descriptions of a set of

schemas. You can access SQL/MX objects with the three-part name of the actual

object.

The ANSI SQL:1999 catalog name is an SQL identifier. In SQL/MX Release 2.x, ANSI

catalogs do not have any physical representation, nor do they have a physical

relationship to SQL/MP catalogs.

A catalog is owned by the user ID that created it, though catalog ownership does not

imply authorization over schemas or objects in that catalog, and any user can drop an

empty catalog, regardless who the catalog owner is. Each of the schemas described in

a catalog has an owner. A catalog can contain multiple schemas, each possibly owned

by a different user. A catalog cannot contain other catalogs. Any user on a node can

create a catalog on that node. The catalog’s owner has the authority to register and

unregister the catalog.

An SQL/MX catalog name can be up to 128 characters and is location-independent.

SQL/MP Catalogs

An SQL/MP catalog is a set of tables and indexes that describe SQL objects. Tables in

the set are called catalog tables and NonStop SQL/MP creates them, along with their

indexes, when you execute a CREATE CATALOG statement. Each catalog resides on

its own Guardian subvolume, and the name of that subvolume is also the name of the

catalog.

A catalog name has the form: [\node.][$volume.]subvol

Each node on which NonStop SQL/MP is used has one special catalog called the

system catalog and might have many other catalogs. Each table, view, index, partition,

collation, or catalog table located on a node must be described in a catalog on the

same node. For more information, see the SQL/MP Reference Manual.

See SET CATALOG Statement on page 2-208 and Object Naming on page 10-48.