(B)0[m[4mFETCH[m qqq> stream-name qqwqqqqqq>qqqqqqwqqqk
mq> on-error qj x
lqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqj
mwqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqwq>
tq> [4mAT[m [4mEND[m qq> statement qqq> [4mEND_FETCH[m qqu
mq> [4mEND_FETCH[m qqqqqqqqqqqqqq>qqqqqqqqqqqqqj
1 – stream-name
Names the stream in which you want to advance the stream pointer.
Oracle Rdb moves the pointer to the next record that it can return.
Because the FETCH statement defines the current record in a
record stream, you must use a FETCH statement before any other
Oracle Rdb data manipulation statement when you are using streams.
2 – on-error
The ON ERROR clause. This clause specifies the action to be taken
if an Oracle Rdb error occurs during the FETCH operation. For more
information, request HELP on ON_ERROR.
3 – statement
Any valid host language or Oracle Rdb statement. The program
executes the statement specified in the AT END clause when no
records remain to be processed in the record stream. If you use
the AT END clause, you must also include END_FETCH.