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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-8
Other Functions and Expressions
See SEQUENCE BY Clause on page 7-19 and the individual entry for each function.
Other Functions and Expressions
Use these other functions and expressions in an SQL value expression:
See the individual entry for the function.
LASTNOTNULL Function
on page 9-81
Returns the last nonnull value for the specified column
expression. If only null values have been returned, returns null.
ROWS SINCE Function
on page 9-143
Returns the number of rows counted since the specified
condition was last true.
THIS Function
on
page 9-174
Used in ROWS SINCE to distinguish between the value of the
column in the current row and the value of the column in
previous rows.
CASE (Conditional)
Expression on
page 9-16
A conditional expression. The two forms of the CASE expression
are simple and searched.
CAST Expression
on
page 9-20
Converts a value from one data type to another data type that you
specify.
CURRENT_USER
Function on page 9-43
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to SESSION_USER
and USER.
HASHPARTFUNC
Function on page 9-74
Returns the number of the partition to which a specified
partitioning key belongs
SESSION_USER
Function on page 9-163
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to CURRENT_USER
and USER.
USER Function
on
page 9-198
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to CURRENT_USER
and SESSION_USER.
NVL Function
on
page 9-118
Returns a specified value when the expression is NULL.
NVL2 Function
on
page 9-120
Returns a specified value when the expression is NULL and, if the
expression is not NULL, returns another specified value.
LNNVL Function
on
page 9-84
Returns TRUE if the condition is FALSE or NULL, and FALSE
when the condition is TRUE.
DECODE Function
on
page 9-50
Compares the given expression to a set of specified conditions
one by one in the specified order. Returns the value
corresponding to the matching condition.
COALESCE Function
on page 9-27
Returns the value of the first expression in the list that is not
NULL. If all the expressions in the list result in NULL, the function
returns NULL.