RDOHELP72.HLB  —  FETCH
    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
Format More Example
Close Help