1  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
 

2  Format

 (B)0AT END qq> statement

 

3  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