SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-10
SCHEMATA Table
SCHEMATA Table
SCHEMATA is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that lists all schemas in all
catalogs that are visible on the node.
Column Name Data Type Description
*1 CAT_UID LARGEINT UID of catalog for schema; link to CATSYS
*2 SCHEMA_NAME CHAR(128) Schema name
3 SCHEMA_UID LARGEINT UID of schema; link to OBJECTS
4 SCHEMA_OWNER INT Owner's user ID
5 SCHEMA_VERSION INT Version of schema:
1200 for R2.x
3000 for R3.0
3100 for R3.1
3200 for R3.2
6 SCHEMA_SUBVOLUME CHAR(8) Name of Guardian subvolume where objects
from schema are stored.
7 CURRENT_OPERATION CHAR(2) Specifies if a schema level operation is active
for the schema. Possible values are:
spaces (no operation)
CO a change ownership operation
DC a DOWNGRADE ALL METADATA IN
CATALOG operation
DG a DOWNGRADE ALL METADATA
operation
UC an UPGRADE ALL METADATA IN
CATALOG operation
UG an UPGRADE ALL METADATA operation
8 SOURCE_VERSION INT The version of the schema before the
execution of the operation indicated by the
CURRENT_OPERATION column. Possible
values are:
0 (if no operation is in progress)
1200 for R2.0
3000 for R3.0
3100 for R3.1
3200 for R3.2
9 TARGET_VERSION INT The target version of the operation indicated
by the CURRENT_OPERATION column.
Possible values are:
0 (if no operation is in progress)
3000 for R3.0
1200 for R2.0
3100 for R3.1
3200 for R3.2
* Indicates primary key