SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xlii
9. SQL/MX File Attributes
TO_CHAR(<NUMERIC>) Function 8-181
Considerations 8-183
Examples of TO_CHAR(<NUMERIC>) 8-185
TO_CHAR(<DATETIME>) Function 8-185
Considerations 8-189
Examples of TO_CHAR(<DATETIME>) 8-190
TRANSLATE Function 8-190
TRIM Function 8-192
Considerations for TRIM 8-192
Result of TRIM 8-192
Examples of TRIM 8-192
UCASE Function 8-193
Considerations for UCASE 8-193
Examples of UCASE 8-200
UPPER Function 8-201
Examples of UPPER 8-201
UPSHIFT Function 8-202
Examples of UPSHIFT 8-202
USER Function 8-203
Examples of USER 8-203
VERSION_INFO Function 8-204
Example of VERSION_INFO 8-206
VARIANCE Function 8-207
Considerations for VARIANCE 8-207
Definition of VARIANCE 8-207
Data Type of the Result 8-209
Operands of the Expression
8-209
Nulls 8-209
FLOAT(54) and DOUBLE PRECISION Data 8-209
Examples of VARIANCE
8-210
WEEK Function
8-212
Examples of WEEK 8-212
YEAR Function
8-213
Examples of YEAR
8-213
9. SQL/MX File Attributes
ALLOCATE/DEALLOCATE 9-2
Considerations for ALLOCATE 9-2
AUDITCOMPRESS
9-3