49-level fields in a host variable. Introduction SQL's active set and cursor to handle multiple rows that meet the selection criteria. Use of the host list for data from the cursor. Closing and re-opening the cursor. Updating Tables Covers all aspects of updating tables from application programs.
Special attention is given to using the cursor to apply changes to many records one at a time.
Direct Updates Possible values for updates and inserts. Updating or deleting a row without first reading it. Updates and deletes affecting many rows. Updates with a cursor. Deleting the current row of the active set.