(B)0[m[4mMODIFY[m qqq> context-var qqqk lqqqqqqqqqq<qqqqqqqqqj mqq> [4mUSING[m qqqqwqqqqqqqq>qqqqqqwqqqqqk mqq> on-error qqj x lqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqj tqqwq> context-var . field-name qq> = qqq> value-expr qqwqk x mqqqqqqqqqqqqqqqqqqqq ; <qqqqqqqqqqqqqqqqqqqqqqqqqqj x mqqqq> context-var . * qqqqqqqqq> = qqq> record-descr qqqqu lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqj mqqqq> [4mEND_MODIFY[m qqqq>
1 – on-error
The ON ERROR clause, which specifies a host language statement to be performed if an Oracle Rdb error occurs.
2 – context-var
A context variable declared in the FOR or START_STREAM statement. The MODIFY statement must appear after FOR or START_STREAM and before END_FOR or END_STREAM. You can modify fields in only one relation at a time. That is, all the context variables on the left side of the assignment in a MODIFY statement must refer to the same relation.
3 – record-descr
A valid data dictionary record descriptor matching all the fields of the relation.
4 – field-name
The name of the field to be modified.
5 – value-expr
an Oracle Rdb value expression that specifies the new value for the modified field.