Nonstop Database, HiRDB Version 9 UAP Development Guide
To delete rows in a table, a cursor can be used to verify each row's contents and delete the rows one row at a time. The following figure shows the procedure for using a cursor to delete rows in a table.
Figure 2-16 Procedure for deleting a table
The steps of the processing procedure shown in Figure 2-16 are basically the same as the steps in Figure 2-6, except for data deletion.
The figure below shows an example of using a cursor to delete data one row at a time. It is assumed that the steps up to data fetching have been completed.
Figure 2-17 Example of using a cursor to delete rows
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.