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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxvii
8. SQL/MX Functions and Expressions
EXP Function 8-65
Examples of EXP 8-65
EXPLAIN Function 8-66
Considerations for EXPLAIN 8-67
Using a Statement Pattern 8-67
Using EXPLAIN and EXPLAIN Statement 8-67
Result of the EXPLAIN Function 8-67
Examples of EXPLAIN 8-72
EXTRACT Function 8-75
Examples of EXTRACT 8-75
FEATURE_VERSION_INFO Function 8-76
Input and Output Parameters 8-76
Example of FEATURE_VERSION_INFO 8-77
FLOOR Function 8-78
Examples of FLOOR 8-78
HASHPARTFUNC Function 8-79
Considerations for HashPartFunc 8-79
Examples of HashPartFunc 8-79
HOUR Function 8-83
Examples of HOUR 8-83
INSERT Function 8-84
Examples of INSERT 8-84
JULIANTIMESTAMP Function 8-85
Examples of JULIANTIMESTAMP 8-85
LASTNOTNULL Function 8-86
Examples of LASTNOTNULL 8-86
LCASE Function
8-87
Examples of LCASE 8-87
LEFT Function 8-88
Examples of LEFT
8-88
LNNVL Function
8-89
Examples of LNNVL 8-90
LOCATE Function
8-91
Considerations for LOCATE
8-92
Result of LOCATE
8-92
Using UCASE
8-92
Examples of LOCATE 8-92
LOG Function
8-93
Examples of LOG 8-93