SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxi
9. SQL/MX Functions and Expressions
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-6
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
Examples of AVG 9-15
CASE (Conditional) Expression 9-16
Considerations for CASE
9-17
Examples of CASE
9-18
CAST Expression 9-20
Considerations for CAST
9-20
Valid Conversions for CAST
9-20
Examples of CAST
9-21
CEILING Function
9-22
Examples of CEILING 9-22
CHAR Function
9-23