VMS Help  —  RDML72  Statements  STORE Statement, Format  Format arguments
    handle-options         A request handle, a transaction handle, or
                           both.

    REQUEST_HANDLE var     The REQUEST_HANDLE keyword followed by a
                           host language variable. A request handle
                           identifies a compiled Oracle Rdb request.
                           If you do not supply a request handle
                           explicitly, RDML associates a unique
                           request handle for the compiled request.

    TRANSACTION_HANDLE     The TRANSACTION_HANDLE keyword followed by
    var                    a host language variable. A transaction
                           handle identifies a transaction. If
                           you do not supply a transaction handle
                           explicitly, RDML uses the default
                           transaction handle.

    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.

    db-handle              Database handle. A host variable used
                           to refer to a specific database you have
                           invoked. For more information see the
                           entry on the Database Handle clause.

    relation-name          The name of a relation in the database.

    on-error               The ON ERROR clause. The first occurrence
                           specifies host language or RDML
                           statement(s) to be performed if an error
                           occurs during the STORE operation. The
                           second occurrence 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.

    statement              Any valid RDML or host language statement,
                           except the GET statement, to be executed
                           during the STORE operation. Use a
                           semicolon (;) at the end of each RDML,
                           Pascal, or C statement.

    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 to appear
                           before the END_STORE statement.

    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
                           fields of 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.

    statistical-expr       A statistical expression; calculates
                           values based on a value expression for
                           every record in the record stream.
Close Help