Nonstop Database, HiRDB Version 9 UAP Development Guide
Multiple retrieved rows are updated by using a cursor to retrieve one row at a time. The following figure shows how to use a cursor to update a table.
Figure 2-11 Procedure for updating a table
The steps of the processing procedure shown in Figure 2-11 are basically the same as the steps in Figure 2-6, except for data updating.
The following figure shows an example of using a cursor to update a table. It is assumed that the steps up to data fetching have been completed.
Figure 2-12 Example of using a cursor to update a table
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.