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

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-51
Rowset Expressions
Examples of Numeric Value Expressions
These are examples of numeric value expressions:
Rowset Expressions
An expression that contains a rowset host variable or rowset parameter as one of its
operands is called a rowset expression. A rowset expression is an array of single value
expressions, where the operands for the nth single value expression are obtained from
the nth rowset element. All array elements in a given rowset expression are of identical
type.
For more information about rowsets, see the SQL/MX Programming Manual for C and
COBOL.
-57 Numeric literal.
salary * 1.10 The product of the values in the SALARY column
and a numeric literal.
unit_price * qty_ordered The product of the values in the UNIT_PRICE and
QTY_ORDERED columns.
12 * (7 - 4) An expression whose operands are numeric
literals.
COUNT (DISTINCT city) Function applied to the values in a column.