(B)0[mget-statement = [4mGET[m qqwqqqq>qqqqqqqqwqqwq> get-item qqwqqqqq> [4mEND_GET[m qqq> mq> on-error qj mqqqqq ; <qqqqqqj (B)0[mget-item = qqqqwqq> host-var qqqqqqqq> = qqqqq> value-expr qqqqqqqqqqwqqqq> tqq> record-descr qqqq> = qqqqq> context-var.* qqqqqqqu mqq> host-var qqqqqqqq> = qqqqq> statistical-expr qqqqj
1 – Format arguments
on-error The ON ERROR clause. Specifies host language or RDML statement(s) to be performed if an error occurs during the GET operation. For more information see the entry on ON ERROR. get-item The GET statement includes an assignment statement specifying a host variable and a database value. The database value is assigned to the host variable from the Oracle Rdb value expression or statistical expression. Note that the GET statement must be the last statement before END_STORE when it is used in a STORE ... END_STORE block. host-var A valid variable name declared in the host program. value-expr A valid RDML value expression. The value expression can include the "<context- variable>.RDB$DB_KEY" expression. record-descr A valid host language record descriptor that contains an entry for each field in the relation. Each field of the record descriptor must match exactly the field names and data types of the fields in the Oracle Rdb relation referenced by the context variable. context-var A context variable. A temporary name that you associate with a relation. You define a context variable in a relation clause. For more information see the entry on Context Variables. statistical-expr A statistical expression; calculates values based on a value expression for every record in the record stream.