SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xxv
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
Examples of TANH 9-155
THIS Function 9-156
Considerations for THIS 9-156
Example of THIS 9-156
TRANSLATE Function 9-158
TRIM Function 9-160
Considerations for TRIM 9-160
Examples of TRIM 9-160
UCASE Function 9-161
Considerations for UCASE 9-161
Examples of UCASE 9-168
UPPER Function 9-169
Examples of UPPER 9-169
UPSHIFT Function 9-170
Examples of UPSHIFT 9-170
USER Function 9-172
Examples of USER 9-172
VARIANCE Function 9-173
Considerations for VARIANCE 9-173
Examples of VARIANCE 9-176
WEEK Function 9-178
Examples of WEEK 9-178
YEAR Function 9-179
Examples of YEAR 9-179
10. Metadata Tables
Changes to 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-3
System Defaults Tables (User Metadata Tables): Schema
SYSTEM_DEFAULTS_SCHEMA 10-5
MXCS Metadata Tables: Schema MXCS_SCHEMA 10-5
Histogram Tables 10-6
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA 10-6
System Schema Tables 10-7