HELPLIB.HLB  —  RDML72  Statements  GET  Format
  (B)0get-statement =

   GET qqwqqqq>qqqqqqqqwqqwq> get-item  qqwqqqqq> END_GET qqq>
         mq> on-error qj  mqqqqq ; <qqqqqqj

  (B)0get-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.
Close Help