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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxviii
10. Metadata Tables
UCASE Function 9-188
Considerations for UCASE 9-188
Examples of UCASE 9-195
UPPER Function 9-196
Examples of UPPER 9-196
UPSHIFT Function 9-197
Examples of UPSHIFT 9-197
USER Function 9-198
Examples of USER 9-198
VERSION_INFO Function 9-199
Example of VERSION_INFO 9-201
VARIANCE Function 9-202
Considerations for VARIANCE 9-202
Examples of VARIANCE 9-205
WEEK Function 9-207
Examples of WEEK 9-207
YEAR Function 9-208
Examples of YEAR 9-208
10. Metadata Tables
SQL/MX Metadata Catalogs 10-2
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-3
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
Security Schema Tables: Schema SYSTEM_SECURITY_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-11
System Security Schema Tables 10-11
MGM_PRIVILEGES
10-11
PRIVILEGED_USERS TABLE 10-11