Retrieves the next record from a record stream. The FETCH
statement is used:
o After a START_STREAM statement
o Before any other RDML statements that affect the context
established by the START_STREAM statement
The FETCH statement advances the pointer for a record stream to
the next record of a relation. Unlike the FOR statement, which
advances to the next record automatically, the FETCH statement
allows you explicit control of the record stream. For instance,
you might use the FETCH statement to print a report where the
first six rows have five columns, and the seventh row only three.
Additional Information:
explode
extract