Procedure Definition Language Statements › DELETE Statement

DELETE Statement

The DELETE statement deletes the entire current record or row that an updateable dataview references. This applies only to SQL and CA Datacom/DB native access dataviews. You can use the DELETE statement only in a FOR FIRST, a FOR EACH, or a FOR ANY construct.

This statement has the following format:

DELETE dataview_name

dataview_name

Identifies the dataview where the current record or row is deleted.

DELETE does not apply to sequential or VSAM EDS files.

A DELETE is immediate and is not canceled by a QUIT in a FOR construct that contains the DELETE.

The entire record or row is deleted even if the dataview references only a subset of the fields in the record or row.

After a DELETE, you cannot reference the deleted record or row.

Example

FOR FIRST INVEN
    WHERE ITEM_NO = DESIRED_ITEM_NO
        DELETE INVEN
WHEN NONE
        DO INVALID_DEL
ENDFOR