SQL$HELP72.HLB  —  FETCH  Arguments  fetch FROM
    Specifies the specific segment of the list cursor to fetch. These
    options are available only if you specified the SCROLL option in
    the DECLARE CURSOR statement. The choices are:

    o  NEXT

       Fetches the next segment of the list cursor. This is the
       default.

    o  PRIOR

       Fetches the segment immediately before the current segment of
       the list cursor.

    o  FIRST

       Fetches the first segment of the list cursor.

    o  LAST

       Fetches the last segment of the list cursor.

    o  RELATIVE simple-value-expression

       Fetches the segment of the list cursor indicated by the value
       expression. For example, relative -4 would fetch the segment
       that is four segments prior to the current segment.

    o  ABSOLUTE simple-value-expression

       Fetches the segment of the list cursor indicated by the value
       expression. For example, absolute 4 would fetch the fourth
       segment of the list cursor.
Close Help