SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
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-134
Returns the sum of nonnull values of a column expression up to
and including the current row.
RUNNINGVARIANCE
Function on page 9-136
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-68
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-120
Returns the number of rows counted since the specified
condition was last true.
THIS Function
on
page 9-150
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-37
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-61
Returns the number of the partition to which a specified
partitioning key belongs
SESSION_USER
Function on page 9-139
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-165
Returns the Guardian user name corresponding to the current
authorization ID. This function is equivalent to CURRENT_USER
and SESSION_USER.