Nonstop Database, HiRDB Version 9 UAP Development Guide
If a condition is specified for data deletion, all rows that satisfy the condition are deleted. To delete by specifying a condition, the WHERE clause must be specified in the DELETE statement.
The following figure shows, as an example of deletion with a condition specified, the procedure for deleting from the stock table only the items whose product name is SKIRT.
Figure 2-18 Example of deletion with a condition specified
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.