(B)0[m[4mFOR[m qwqqqqqqqqqq>qqqqqqqqwqq> rse qqwqqqqqqq>qqqqqqqwqqk
mq> handle-options qj mqq> on-error qqj x
lqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqwq> statement qwqqqqqq> [4mEND_FOR[m qqqqqqqqq>
mqqqqqqqq<qqqqqj
1 – rse
Any valid record selection expression. Request HELP on RSE for a
complete discussion of record selection expressions.
2 – on-error
(B)0[m[4mON[m [4mERROR[m qwq> statement qwq> [4mEND_ERROR[m
mqqqqqqqq<qqqqqj
The ON ERROR clause. This clause specifies the action to be taken
if an error occurs while Oracle Rdb is compiling the RSE. Request
HELP for ON_ERROR for more information.
3 – statement
Any valid Oracle Rdb data manipulation statement or host language
statement except INVOKE, COMMIT, or ROLLBACK.
No statement within the FOR loop can redefine the context
variable that was defined by the RSE in the FOR statement.
4 – handle-options
(B)0[mhandle-options =
qq> ( qwq> [4mREQUEST_HANDLE[m qqq> var qqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qq>
tq> [4mTRANSACTION_HANDLE[m qqq> var qqqqqqqqqqqqqqqqqqqqqqqu
mq> [4mREQUEST_HANDLE[m q> var , [4mTRANSACTION_HANDLE[m q> var qj
4.1 – REQUEST_HANDLE
A keyword followed by a host language variable. A request handle
points to the location of a compiled Oracle Rdb request. If you
do not supply a request handle explicitly, Oracle Rdb associates a
default request handle with the compiled request. Your must use
a request handle when you want to make an identical query to two
different databases.
In Callable RDO, use !VAL as a marker for host language
variables.
You can put parentheses around the host language variable name.
4.2 – TRANSACTION_HANDLE
A keyword followed by a host language variable. A transaction
handle identifies each instance of a transaction. If you do not
declare the transaction handle explicitly, Oracle Rdb attaches an
internal identifier to the transaction.
In Callable RDO, use !VAL as a marker for host language
variables.
You can put parentheses around the host language variable name.
Normally, you do not need to use this argument. The ability to
declare a transaction handle is provided for compatibility with
other database products and future releases of Oracle Rdb.