SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xxv
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
THIS Function 9-150
Considerations for THIS 9-150
Example of THIS 9-150
TRANSLATE Function 9-152
TRIM Function 9-154
Considerations for TRIM 9-154
Examples of TRIM 9-154
UCASE Function 9-155
Considerations for UCASE 9-155
Examples of UCASE 9-162
UPPER Function 9-163
Examples of UPPER 9-163
UPSHIFT Function 9-164
Examples of UPSHIFT 9-164
USER Function 9-165
Examples of USER 9-165
VARIANCE Function 9-166
Considerations for VARIANCE 9-166
Examples of VARIANCE 9-169
WEEK Function 9-171
Examples of WEEK 9-171
YEAR Function 9-172
Examples of YEAR 9-172
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