Calculate values based on a value expression for every record
in a record stream. You do not specify a value expression for
the COUNT statistical function because it operates on the record
stream formed by the RSE, not on a value expression. When you
use the AVERAGE, MAX, MIN, and TOTAL statistical functions, you
specify a value expression and a record selection expression
(RSE). Oracle Rdb then:
o Evaluates the value expression for each record in the record
stream formed by the RSE
o Calculates a single value based on the results of the first
step
The RDML Statistical functions are:
o AVERAGE
o COUNT
o MIN
o MAX
o TOTAL
For more information and the syntax diagrams see the HELP entry
on each of these functions.
1 – Format
(B)0[mstatistical-expr =
qqqwqq> [4mMAX[m qqqqqwqq> value-expr qwqqqqqqqqqqqqqqqqqqqqqk
tqq> [4mMIN[m qqqqqu x x
tqq> [4mTOTAL[m qqqu x x
tqq> [4mAVERAGE[m qj x x
mqq> [4mCOUNT[m qqqqqqqqqqqqqqqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqqqqqqqqqqqqqqq>qqqqqqqwqq>qqqqqqqqqqqqqqqqqqqqwqqqk
mqq> handle-options qqqj x
x
lqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqq> [4mOF[m qqqqqqq> rse qqqqqqqqqqqqqqqqqqqqqqqqqqqqq>
1.1 – Format arguments
value-expr A value expression. A symbol or a string
of symbols used to calculate a value. When
you use a value expression in a statement,
Oracle Rdb calculates the value associated
with the expression and uses that value
when executing the statement.
handle-options A transaction handle, a request handle, or
both.
rse A record selection expression. A phrase
that defines specific conditions that
individual records must meet before
Oracle Rdb includes them in a record stream.