SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xix
7. SQL/MX Clauses (continued)
7. SQL/MX Clauses (continued)
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
ATAN Function 9-13
Examples of ATAN 9-13
ATAN2 Function 9-13
Examples of ATAN2 9-13
AVG Function 9-14
Considerations for AVG 9-14