Procedure Definition Language Statements › FOR Constructs (CA Datacom/DB Native Access) › Set Processing

Set Processing

The FOR EACH, FOR FIRST, and FOR ANY constructs retrieve and update a set of records. These constructs are iterative. With each iteration, it returns the next record in the requested set. It is not necessary to create an image of the record in working data since the dataview referenced in the FOR construct contains a data structure to hold the record retrieved by each iteration of the FOR. PDL statements can use the fields in this structure. The database is automatically updated at the ENDFOR for the current iteration.