(B)0[m[4mSTART_STREAM[m qqqqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqqqwqqqqqk
mqqqqqq> handle-options qqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mq> stream-name q> [4mUSING[m qqq> rse qqqwqqqqqqqq>qqqqqqwq>
mqq> on-error qqj
1 – 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
1.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.
1.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.
2 – stream-name
The name of the stream that you create. You refer to the stream
name only when you want to move the stream pointer (FETCH) or
terminate the stream (END_STREAM). Use a context variable for all
other purposes.
3 – on-error
The ON ERROR clause. This clause specifies the action to be taken
if an Oracle Rdb error occurs while Oracle Rdb is compiling the RSE in
the START_STREAM statement.
4 – rse
A record selection expression. This RSE specifies the records
included in the record stream.
Any context variables that you define with the START_STREAM
statement are valid for the life of that stream only.
Once you have defined a context variable in the record selection
expression, you cannot redefine that context variable elsewhere
until you have ended the stream.