HELPLIB.HLB  —  RDML72  Statements  GET
    Assigns values from data records in a record stream to host
    variables in RDML programs. You can use the GET statement in
    three different ways:

    o  When you establish a record stream with the FOR or
       START_STREAM statement, you use the GET statement to assign
       values from the current record in the stream to variables in
       your program. In the case of the START_STREAM statement, you
       also need a FETCH statement to indicate the current record in
       the stream.

    o  You can use GET within a STORE operation to retrieve the value
       of the record currently being stored. This includes the use of
       GET ... RDB$DB_KEY in a STORE ... END_STORE block to retrieve
       the database key (dbkey) of a record just stored.

    o  You can also use the GET statement alone, without a FOR,
       FETCH, or STORE statement to retrieve the result of a
       statistical expression. The record stream is formed by the
       record selection expression within the statistical expression.
Additional Information: explode extract
Examples Format
Close Help