RDOHELP72.HLB  —  AT_END
    Specifies the statement a program performs if a FETCH statement
    reaches the end of a record stream. You can use the AT END clause
    only with the FETCH statement in a program.

    Example:

    &RDB&  FETCH STREAM_X
    &RDB&    AT END
               GO TO END_OF_STREAM.
    &RDB&  END_FETCH

1  –  Format

  (B)0AT END qq> statement

1.1  –  statement

    Any valid host language or Oracle Rdb statement.

2  –  Example

    The following lines from a COBOL program branch to a COBOL label
    elsewhere in the program to continue processing when Oracle Rdb
    reaches the end of the record stream STREAM_X:

    &RDB&  FETCH STREAM_X
    &RDB&    AT END
               GO TO END_OF_STREAM.
    &RDB&  END_FETCH
Close Help