The example2.cp sample program demonstrates updating 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.
Requires the user to confirm the update before sending the data to Adaptive Server.
