SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-2
SQL/MX Metadata Catalogs
without the surrounding double quotes, and with two consecutive double quotes
collapsed into one double quote.
•
Unless otherwise stated, CHAR(n) in the data type field without a character set
qualifier is associated with the ISO88591 character set. All character types are
searched or sorted with the DEFAULT (binary) collation with the PAD SPACE
characteristic.
For SQL/MX Release 3.0, these tables are visible but are not supported and are
reserved for future use:
•
EXCEPTION_USAGE
•
HISTOGRAM_FREQ_VALS
•
MODULES
•
MVGROUPS
•
MVS
•
MVS_COLS
•
MVS_JOIN_COLS
•
MVS_TABLE_INFO
•
MVS_USED
•
MVS_TABLE_INFO_UMD
•
MVS_USED_UMD
•
SCH_PRIVILEGES
•
SEQUENCE_GENERATORS
•
SG_USAGE
•
SYNONYM_USAGE
SQL/MX Metadata Catalogs
There is one system catalog per node where NonStop SQL/MX has been initialized. It
is stored in NONSTOP_SQLMX_nodename on the Data Access Manager volume
specified as the system metadata volume during installation.There are five schemas in
the system catalog:
•
DEFINITION_SCHEMA_VERSION_vernum.
•
MXCS_SCHEMA
•
SYSTEM_DEFAULTS_SCHEMA
•
SYSTEM_SCHEMA
•
SYSTEM_SQLJ_SCHEMA
You can create as many user catalogs as you wish on a node. Each will contain a
DEFINITION_SCHEMA_VERSION_vernum schema.