Page History
7.35 DELETE
The DELETE command allows the user to delete records from a file either by key or relative record number.
Portability Considerations | Refer to parameter FROM_FILE. |
Also See
7.35.2 DELETE Comments / Warnings
| Panel | ||
|---|---|---|
| ||
Required DELETE -- | ||
| Code Block | ||
| Required
DELETE ------- FROM_FILE -------- file name . library name -----------> -------------------------------------------------------------------------- Optional >-- WHERE--- >-- WHERE ----------- 'condition' --------------------------> >>-- WITH_KEY --------- key value ---------------------------> | expandable group expression | --- 20 maximum
>-- IO_STATUS ------- *STATUS -----------------------------> field name >
>-- IO_ERROR -------- *ABORT ------------------------------> *NEXT *RETURN label >-- VAL_ERROR
>-- VAL_ERROR ------ *LASTDIS ------------------------------> *NEXT *RETURN label >-- NOT_FOUND ---- *NEXT
>-- NOT_FOUND --- *NEXT ----------------------------------> *RETURN label >-- ISSUE_MSG
>-- ISSUE_MSG ------ *NO -----------------------------------> *YES >-- WITH_RRN
>-- WITH_RRN ------- *NONE --------------------------------> >>-- RETURN_RRN --- *NONE ---------------------------------> >>-- CHECK_ONLY ---- *NO ------------------------------------> *YES >-- AUTOCOMMIT --- *FILEDEF
>-- AUTOCOMMIT -- *FILEDEF ---------------------------------| *YES
|