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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-8
Other Functions and Expressions
See SEQUENCE BY Clause on page 7-18 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.
RUNNINGSUM Function
on page 9-136
Returns the sum of nonnull values of a column expression up to
and including the current row.
RUNNINGVARIANCE
Function on page 9-138
Returns the variance of nonnull values of a column expression
up to and including the current row.
Other sequence functions:
LASTNOTNULL Function
on page 9-67
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-122
Returns the number of rows counted since the specified
condition was last true.
THIS Function
on
page 9-156
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-18
A conditional expression. The two forms of the CASE expression
are simple and searched.
CAST Expression
on
page 9-22
Converts a value from one data type to another data type that
you specify.
CURRENT_USER
Function on page 9-41
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to SESSION_USER
and USER.
SESSION_USER
Function on page 9-141
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-172
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to
CURRENT_USER and SESSION_USER.