Neoview SQL Reference Manual (R2.4 SP2)

Returns the number of rows counted since the specified
set of values last changed.
“ROWS SINCE CHANGED Function” (page 441)
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.
“THIS Function” (page 464)
See “SEQUENCE BY Clause” (page 314) and the individual entry for each function.
Other Functions and Expressions
Use these other functions and expressions in an SQL value expression:
Performs 'and' operation on corresponding bits of the two
operands.
“BITAND Function” (page 341)
A conditional expression. The two forms of the CASE
expression are simple and searched.
“CASE (Conditional) Expression” (page 342)
Converts a value from one data type to another data type
that you specify.
“CAST Expression” (page 345)
Returns the value of the first expression in the list that
does not have a NULL value or if all the expressions have
NULL values, the function returns a NULL value.
“COALESCE Function” (page 350)
Converts the specified value expression to hexadecimal
for display purposes.
“CONVERTTOHEX Function” (page 354)
Returns the role you logged in as.“CURRENT_ROLE Function” (page 363)
Returns the user name you logged in as.“CURRENT_USER Function” (page 366)
Compares expr to each test_expr value one by one in
the order provided.
“DECODE Function” (page 380)
Generates a result table describing an access plan for a
SELECT, INSERT, DELETE, UPDATE, or CALL statement.
“EXPLAIN Function” (page 389)
Returns the first argument if it is not null, otherwise it
returns the second argument.
“ISNULL Function” (page 396)
Returns the value of the first operand if the two operands
are not equal, otherwise it returns NULL.
“NULLIF Function” (page 422)
Returns the value of the first operand unless it is NULL,
in which case it returns the value of the second operand.
“NVL Function” (page 424)
Returns the user name you logged in as.“USER Function” (page 472)
See the individual entry for the function.
Categories 331