example2 demonstrates how to update a row using 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 SQL Server/Adaptive Server after the user confirms the update.