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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxiii
8. SQL/MX Functions and Expressions
Considerations for SAMPLE 7-11
Sample Rows 7-11
Cluster Sampling 7-11
Examples of SAMPLE 7-12
SEQUENCE BY Clause 7-19
Considerations for SEQUENCE BY 7-19
Examples of SEQUENCE BY 7-21
STORE BY Clause 7-23
Considerations for STORE BY 7-24
Storage Order and Partitioning 7-24
Effect of Storage Order on Partitioning 7-25
Primary Key Storage Order 7-25
SYSKEY Storage Order 7-25
Key Column List Storage Order 7-25
TRANSPOSE Clause 7-26
Considerations for TRANSPOSE 7-28
Multiple TRANSPOSE Clauses and Sets 7-28
Degree and Column Order of the TRANSPOSE Result 7-28
Data Type of the TRANSPOSE Result 7-28
Cardinality of the TRANSPOSE Result 7-29
Examples of TRANSPOSE 7-30
8. SQL/MX Functions and Expressions
Categories 8-1
Aggregate (Set) Functions 8-1
Character String Functions
8-2
Datetime Functions
8-4
Mathematical Functions
8-5
Sequence Functions 8-7
Other Functions and Expressions 8-8
Table-Valued Stored Functions
8-9
ABS Function
8-10
Examples of ABS 8-10
ACOS Function
8-10
Examples of ACOS
8-10
ABS Function
8-10
Examples of ABS
8-10
ACOS Function 8-10
Examples of ACOS
8-10