SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-21
REPLICAS Table
REPLICAS Table
REPLICAS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
stores the locations of views in the catalog.
SYSTEM_NAME, DATA_SOURCE, and FILE_SUFFIX are stored in uppercase letters.
RI_UNIQUE_USAGE Table
RI_UNIQUE_USAGE is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that links unique constraints in the
catalog with referential constraints that reference them:
7 DELETE_RULE CHAR(2) RE RESTRICT
NA NO ACTION
SD SET DEFAULT
SN SET NULL
* Indicates primary key
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of view
*2 SYSTEM_NAME CHAR(8) Name of node with view label, including
leading “\” (backslash)
*3 DATA_SOURCE CHAR(8) Name of volume with view label,
including leading “$” (dollar sign)
*4 FILE_SUFFIX CHAR(18) Subvolume and simple name of name of
file with view label
* Indicates primary key
Column Name Data Type Description
*1 UNIQUE_CONSTRAINT_UID LARGEINT UID of unique constraint
*2 FOREIGN_KEY_CATALOG_UID LARGEINT UID of referencing catalog
*3 FOREIGN_KEY_SCHEMA_UID LARGEINT UID of referencing schema
*4 FOREIGN_KEY_UID LARGEINT UID of referential constraint
* Indicates primary key
Column Name Data Type Description