SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxi
8. SQL/MX File Attributes
Examples of SEQUENCE BY 7-21
STORE BY Clause 7-23
Considerations for STORE BY 7-24
Effect of Storage Order on Partitioning 7-25
TRANSPOSE Clause 7-26
Considerations for TRANSPOSE 7-28
Examples of TRANSPOSE 7-30
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
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