RDOHELP72.HLB  —  RSE  Format  first-clause  More
    Note the following rules:

    o  Oracle Rdb does not guarantee the order of records in a record
       stream unless you specify a sort order. For this reason, when
       you use FIRST n in the RSE, the actual records in the record
       stream are unpredictable. Therefore, you should always specify
       SORT when you use FIRST n.

    o  If n evaluates to zero or a negative number, the record stream
       will be empty.

    o  If you specify FIRST n and n is greater than the number
       of records satisfying those conditions, the record stream
       consists of all records meeting the conditions of the record
       selection expression.

    o  If n is not an integer, Oracle Rdb rounds any fractional part
       of the value and uses the remaining integer as the number of
       records in the record stream.
Close Help