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

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xx
7. SQL/MX Clauses (continued)
7. SQL/MX Clauses (continued)
Examples of SEQUENCE BY 7-20
STORE BY Clause 7-22
Considerations for STORE BY 7-23
Effect of Storage Order on Partitioning 7-24
TRANSPOSE Clause 7-25
Considerations for TRANSPOSE 7-27
Examples of TRANSPOSE 7-29
8. SQL/MX File Attributes
ALLOCATE/DEALLOCATE 8-2
Considerations for ALLOCATE 8-2
AUDITCOMPRESS 8-3
Considerations for AUDITCOMPRESS 8-3
BLOCKSIZE 8-4
CLEARONPURGE 8-5
Considerations for CLEARONPURGE 8-5
EXTENT 8-6
Considerations for EXTENT 8-6
MAXEXTENTS 8-7
Considerations for MAXEXTENTS 8-7
9. SQL/MX Functions and Expressions
Categories 9-1
Aggregate (Set) Functions 9-1
Character String Functions 9-2
Datetime Functions 9-4
Mathematical Functions 9-5
Sequence Functions 9-7
Other Functions and Expressions 9-8
Table-Valued Stored Functions 9-9
ABS Function 9-10
Examples of ABS 9-10
ACOS Function 9-10
Examples of ACOS 9-10
ASCII Function 9-11
Examples of ASCII 9-11
ASIN Function 9-12
Examples of ASIN 9-12