The following programs demonstrate the use of the FOR statement
to retrieve segmented strings. Since the PERSONNEL database does
not have any segmented strings stored, the programs first store
three strings in the RESUME field of the RESUMES relation (for
more information on storing segmented strings, see the help entry
on STORE Statement with segmented strings). The programs retrieve
the segmented strings using a nested FOR statement. The outer FOR
statement selects a record based on EMPLOYEE_ID. The inner FOR
statement prints each segmented string stored in RESUME for the
selected employee.
Additional Information:
explode
extract