FETCH

Reference

Syntax

FETCH NEXT CURSOR dbcur
    { { INTO { {[CORRESPONDING FIELDS OF] wa} | (dobj1, dobj2, ...) } }
    | { INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab
                       [PACKAGE SIZE n] } } .

Effect

Extracts lines from the resulting set of a database-cursor opened withOPENCURSOR.

Additions

• INTO wa
  Reads a line and assigns it to a work area wa.
  
  
• INTO (dobj1, dobj2, ...)
  Reads a line and assigns it to several data objects dobj1, dobj2, ...
  
  
• INTO|APPENDING TABLE itab
  Reads several lines and assigns them to an internal table itab resp. attaches them to the table.
  
  
• CORRESPONDING FIELDS OF
  Restricts the transport to homonymous components of the work areas wa resp. to the internal table itab.
  
  
• PACKAGE SIZE n
  Hands over the lines in pakets from n lines to the internal table itab.