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

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xxvii
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
TRIM Function 9-165
Considerations for TRIM 9-165
Examples of TRIM 9-165
UCASE Function 9-166
Considerations for UCASE 9-166
Examples of UCASE 9-173
UPPER Function 9-174
Examples of UPPER 9-174
UPSHIFT Function 9-175
Examples of UPSHIFT 9-175
USER Function 9-176
Examples of USER 9-176
VERSION_INFO Function 9-177
Example of VERSION_INFO 9-179
VARIANCE Function 9-180
Considerations for VARIANCE 9-180
Examples of VARIANCE 9-183
WEEK Function 9-185
Examples of WEEK 9-185
YEAR Function 9-186
Examples of YEAR 9-186
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
System Schema Tables 10-8
ALL_UIDS Table 10-8
CATSYS Table 10-9
CAT_REFERENCES Table 10-9
SCHEMATA Table 10-10