Example 1

    Retrieve all the field values from one or more relations

    RDO> START_TRANSACTION READ_ONLY
    RDO>
    RDO>  FOR E IN EMPLOYEES
    cont>  PRINT E.*
    cont> END_FOR
    RDO>
    RDO> COMMIT

    You can use the wildcard character (*) to display all fields from
    one or more relations named in your RSE. RDO displays the names
    of the fields as column headers and displays the corresponding
    field values beneath them. When you use the wildcard character,
    you cannot display values for segmented strings, literals, or
    statistical expressions.

    This RDO query displays all the field values from each record in
    the EMPLOYEES relation.

    Example 2

    Retrieve values from named fields in a relation:

    RDO> START_TRANSACTION READ_ONLY
    RDO>
    RDO>  FOR E IN EMPLOYEES
    cont>  PRINT E.LAST_NAME, E.FIRST_NAME, E.MIDDLE_INITIAL
    cont> END_FOR
    RDO>
    RDO> COMMIT

    This RDO query displays field values from each record in the
    EMPLOYEES relation.

    Example 3

    Retrieve values from fields in two relations:

    RDO> START_TRANSACTION READ_ONLY
    RDO>
    RDO>  FOR E IN EMPLOYEES CROSS JH IN JOB_HISTORY
    cont>   OVER EMPLOYEE_ID
    cont>   WITH JH.JOB_END MISSING
    cont>   PRINT E.LAST_NAME, JH.JOB_CODE
    cont> END_FOR
    RDO>
    RDO> COMMIT

    This RDO statement performs a join of two relations and uses
    PRINT to display a value from each. The result is the last name
    and current job code of each employee.

    Example 4

    Retrieve the result of a statistical expression:

    RDO> START_TRANSACTION READ_ONLY
    RDO>
    RDO> PRINT COUNT OF E IN EMPLOYEES WITH
    cont> E.STATE = "MA"
    RDO>
    RDO> COMMIT

    This example retrieves the number of employees who live in
    Massachusetts.