SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-11
CATALOGS Table
CATALOGS Table
The CATALOGS table is a catalog table that describes all the catalogs on a node.
CATALOGS is part of the system catalog for the node and does not exist in
user-created catalogs.
The CATALOGS table is always located on a subvolume named SQL, even if the
system catalog is installed on a subvolume of a different name. As a result, it is
sometimes called the SQL.CATALOGS table. It is always on the same volume as the
system catalog for the node.
The columns CATALOGNAME through CATALOGCLASS (1 through 5) were created in
version 1 of NonStop SQL/MP. The sixth column, CATALOGVERSION, was added in
version 300.
If you have the required authority, you can use the CATALOGS table to obtain
information such as the names of all objects on a node that belong to a particular user.
(Retrieve the names of all catalogs from the table, search each catalog for objects
owned by the user.)
Guardian names in CATALOGS are fully qualified and use uppercase characters.
The ALTER CATALOG command does not affect the system catalog CATALOGS table.
You must alter that table with the ALTER TABLE command.
Table C-2. The SQL.CATALOGS Table
Column Name Data Type Description
1 CATALOGNAME * CHAR(25) Node, volume, and subvolume of a
catalog
2 SUBSYSTEMNAME * CHAR(30) Name of subsystem where catalog resides
3 VERSION CHAR(4) Version of catalog in character format:
A010 = Version 1
A011 = Version 2
A3nn = Version 3nn
4 VERSIONUPGRADETIME LARGEINT
SIGNED
Julian timestamp from last upgrade or
downgrade of catalog
5 CATALOGCLASS CHAR(1) S if system catalog
U if user catalog
6 CATALOGVERSION SMALLINT
UNSIGNED
Version number of catalog
* Indicates primary key