(B)0[m[4mFOR[m qq> context-var qqq> IN qq> ss-field qqwqqqqqqq>qqqqqqwqk
mq> on-error qqj x
lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqwq> get-statement qwqqq> [4mEND_FOR[m qqq>
mqqqqqqqq<qqqqqqqqqj
1 – context-var
A context variable.
2 – ss-field
A qualified field name that refers to a field defined with the
SEGMENTED STRING data type. Note that this field name, like all
field names in a FOR statement, must be qualified by its own
context variable. This second context variable must match the
variable declared in the outer FOR statement. See the Examples
topic.
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 trying to set
up retrieval of the next segmented string. For more details,
request HELP on ON_ERROR.
4 – get-statement
Any valid Oracle Rdb data manipulation language or host language
statement except INVOKE, COMMIT, or ROLLBACK. The GET statement
can reference only the RDB$VALUE and RDB$LENGTH fields.