SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-55
EXP Function
EXP Function
This function returns the exponential value (to the base e) of a numeric value
expression.
EXP is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the EXP function. See Numeric Value Expressions on page 6-50.
Examples of EXP
•
This function returns the value 3.49034295746184208E+000, or approximately
3.4903:
EXP (1.25)
•
This function returns the value 2.0. The function EXP is the inverse of the function
LOG:
EXP (LOG(2.0))
EXPLAIN Function
Considerations for EXPLAIN
Examples of EXPLAIN
The EXPLAIN function is a table-valued stored function that generates a result table
describing an access plan for a SELECT, INSERT, DELETE, UPDATE, or CALL
statement. See Result of the EXPLAIN Function
on page 9-57.
The EXPLAIN function can be specified as a table reference (table) in the FROM
clause of a SELECT statement if it is preceded by the keyword TABLE and surrounded
by parentheses.
The EXPLAIN function is an SQL/MX extension.
'module-name'
is a character string that specifies the full name of a prepared embedded SQL
module, including the catalog name, schema name, and any module management
EXP (numeric-expression)
EXPLAIN (module,'statement-pattern')
module is:
'module-name'
| NULL
MXCI