(B)0[mSTORE qqqqwqq>qqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
mqq> handle-options qj x
x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqq> context-var qqq> [4mIN[m qqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqwq>qqqqqqqqqqqqqqqqqqwqq> relation-name qqqqq> USING qqqqqqqk
mq> db-handle qq> . qj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqwq>qqqqqqqqqqqwqqwq> statement qqqqqqqqqqqqqqqqqqqqqqqqqqqqwk
mq> on-error qj tq> context-var.* qq> = qq> record-descr qux
mqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqjx
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqqqqqwqqqqqqqqqqqqqqqqqqwqqqqqqqqqq> [4mEND_STORE[m
mq> get-statement qj
(B)0[mhandle-options =
q> ( qwqqqqqq> [4mREQUEST_HANDLE[m qqqqq> var qqqqqqqqwq> ) q>
tqqqqqq> [4mTRANSACTION_HANDLE[m qqq> var qqqqqqqqu
mqqqqqq> [4mREQUEST_HANDLE[m q> var q> , qqqqqqqk x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x
mqqqq> [4mTRANSACTION_HANDLE[m q> var qqqqqqqqqqqj
(B)0[mget-statement =
[4mGET[m qqwqqqq>qqqqqqqqwqqwq> get-item qqwqqqqq> [4mEND_GET[m qqq>
mq> on-error qj mqqqqq ; <qqqqqqj
(B)0[mget-item =
qqqqwqq> host-var qqqqqqqq> = qqqqq> value-expr qqqqqqqqqqwqqqq>
tqq> record-descr qqqq> = qqqqq> context-var.* qqqqqqqu
mqq> host-var qqqqqqqq> = qqqqq> statistical-expr qqqqj
1 – Format arguments
handle-options A request handle, a transaction handle, or
both.
REQUEST_HANDLE var The REQUEST_HANDLE keyword followed by a
host language variable. A request handle
identifies a compiled Oracle Rdb request.
If you do not supply a request handle
explicitly, RDML associates a unique
request handle for the compiled request.
TRANSACTION_HANDLE The TRANSACTION_HANDLE keyword followed by
var a host language variable. A transaction
handle identifies a transaction. If
you do not supply a transaction handle
explicitly, RDML uses the default
transaction handle.
context-var A context variable. A temporary name that
you associate with a relation. You define
a context variable in a relation clause.
For more information see the entry on
Context Variables.
db-handle Database handle. A host variable used
to refer to a specific database you have
invoked. For more information see the
entry on the Database Handle clause.
relation-name The name of a relation in the database.
on-error The ON ERROR clause. The first occurrence
specifies host language or RDML
statement(s) to be performed if an error
occurs during the STORE operation. The
second occurrence specifies host language
or RDML statement(s) to be performed if
an error occurs during the GET operation.
For more information see the entry on ON
ERROR.
statement Any valid RDML or host language statement,
except the GET statement, to be executed
during the STORE operation. Use a
semicolon (;) at the end of each RDML,
Pascal, or C statement.
get-item The GET statement includes an assignment
statement specifying a host variable and
a database value. The database value is
assigned to the host variable from the
Oracle Rdb value expression or statistical
expression. Note that the GET statement
must be the last statement to appear
before the END_STORE statement.
host-var A valid variable name declared in the host
program.
value-expr A valid RDML value expression. The value
expression can include the "<context-
variable>.RDB$DB_KEY" expression.
record-descr A valid host language record descriptor
that contains an entry for each field in
fields of the relation. Each field of the
record descriptor must match exactly the
field names and data types of the fields
in the Oracle Rdb relation referenced by
the context variable.
statistical-expr A statistical expression; calculates
values based on a value expression for
every record in the record stream.