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

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxii
9. SQL/MX Functions and Expressions
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
Examples of CHAR 9-23
CHAR_LENGTH Function 9-24
Considerations for CHAR_LENGTH 9-24
SQL/MP Considerations for CHAR_LENGTH 9-24
Examples of CHAR_LENGTH 9-25
COALESCE Function 9-27
Considerations 9-27
Examples of COALESCE
9-28
CODE_VALUE Function 9-30
Considerations for CODE_VALUE Function 9-30
COMPILERCONTROLS Function
9-31
Considerations for COMPILERCONTROLS
9-31
Examples of COMPILERCONTROLS 9-32
CONCAT Function
9-34
Concatenation Operator (||)
9-34
Considerations for CONCAT
9-34
Examples of CONCAT
9-35
CONVERTTIMESTAMP Function 9-36
Considerations for CONVERTTIMESTAMP
9-36
Examples of CONVERTTIMESTAMP 9-36