Nulls DB2's indicator value for null columns. 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. Indirect Updates Reasons to read a row before updating it. Updates with a cursor.