example2.cp shows how to update a row through a cursor. The program:
Displays the columns in the authors table row by row.
Lets the user update author information in all but the au_id column. If the user presses Return for column information, that column’s data remains unchanged.
Sends the data to Adaptive Server after the user confirms the update.