This section describes how to use the DB/Assist dialog boxes to build a SQL DELETE statement. A DELETE statement removes one or more rows in a single table.
With DB/Assist, you can build two forms of DELETE statements:
•A searched DELETE statement removes one or more rows of data.
•A positioned (cursor-based) DELETE statement uses the WHERE CURRENT OF clause to remove a single row of data pointed to by the current cursor position. The cursor is one defined for a previously-created multi-row SELECT statement in your SAM
The following sections describe how to build each form of DELETE statement.
