SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-26
REPLICAS Table
REPLICAS Table
REPLICAS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
stores the locations of views and stored procedures 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:
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