Advances the pointer for a record stream to the next record of
a relation. Once you have established and opened a stream with
the START_STREAM statement, use the FETCH statement to establish
the first record in a relation as the current record. After that,
each FETCH statement makes the next record in the stream the
current one. The FETCH statement only advances the pointer in a
record stream. You must use other data manipulation statements
to manipulate each record. For instance, you might use FETCH to
advance the pointer and the GET statement to assign values from
that record to host language variables.
Example:
RDO> START_STREAM EMPS USING JH IN JOB_HISTORY WITH
cont> JH.EMPLOYEE_ID = "00164" SORTED BY JH.JOB_START
RDO> FETCH EMPS
RDO> PRINT JH.EMPLOYEE_ID, JH.JOB_CODE, JH.JOB_START
Additional Information:
explode
extract