SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xxvi
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
Examples of USER 9-169
VARIANCE Function 9-170
Considerations for VARIANCE 9-170
Examples of VARIANCE 9-173
WEEK Function 9-175
Examples of WEEK 9-175
YEAR Function 9-176
Examples of YEAR 9-176
10. Metadata Tables
Migrating SQL/MP Metadata 10-2
SQL/MX Metadata Catalogs 10-3
SQL/MX Metadata Schemas and Tables 10-3
System Schema Tables: Schema SYSTEM_SCHEMA 10-3
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum 10-4
System Defaults Tables (User Metadata Tables): Schema
SYSTEM_DEFAULTS_SCHEMA 10-5
MXCS Metadata Tables: Schema MXCS_SCHEMA 10-6
Histogram Tables 10-6
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA 10-7
System Schema Tables 10-8
ALL_UIDS Table 10-8
CATSYS Table 10-9
CAT_REFERENCES Table 10-9
SCHEMATA Table 10-10
SCHEMA_REPLICAS Table 10-10
Definition Schema Tables 10-11
ACCESS_PATHS Table 10-11
ACCESS_PATH_COLS Table 10-12
CK_COL_USAGE Table 10-13
CK_TBL_USAGE Table 10-13
COLS Table 10-13
COL_PRIVILEGES Table 10-17
DDL_LOCKS Table 10-18
KEY_COL_USAGE Table 10-18
MP_PARTITIONS Table 10-19
OBJECTS Table 10-19