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

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-2
SQL/MX Metadata Catalogs
•
Unless otherwise stated, character data is stored in uppercase letters except for
character columns that contain delimited identifiers, which are stored as is, but
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 six schemas in
the system catalog:
•
DEFINITION_SCHEMA_VERSION_vernum.
•
MXCS_SCHEMA
•
SYSTEM_DEFAULTS_SCHEMA
•
SYSTEM_SCHEMA
•
SYSTEM_SECURITY_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.