SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-10
SCHEMATA Table
SCHEMATA Table
SCHEMATA is a metadata table in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA that lists all schemas that have
definitions on the node.
Schema names that are regular identifiers are stored in uppercase letters. Schema
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
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
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)
UG the UPGRADE operation
DG the DOWNGRADE 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
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
* Indicates primary key