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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-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:
RUNNINGSUM Function
on page 9-163
Returns the sum of non-null values of a column expression up
to and including the current row.
RUNNINGVARIANCE
Function on page 9-165
Returns the variance of non-null values of a column expression
up to and including the current row.
Other sequence functions:
LASTNOTNULL Function
on page 9-86
Returns the last non-null value for the specified column
expression. If only null values have been returned, returns null.
ROWS SINCE Function
on page 9-148
Returns the number of rows counted since the specified
condition was last true.
THIS Function
on
page 9-179
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-79
Returns the number of the partition to which a specified
partitioning key belongs
SESSION_USER
Function on page 9-168
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-203
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-123
Returns a specified value when the expression is NULL.
NVL2 Function
on
page 9-125
Returns a specified value when the expression is NULL and, if the
expression is not NULL, returns another specified value.