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
Required
DELETE --------- FROM_FILE -------- file name . library name ----------->
-----------------------------------------------------------------------------
Optional
>-- WHERE ----------- 'condition' -------------------------->
>-- WITH_KEY --------- key value --------------------------->
| expandable group expression |
--- 20 maximum --------------
>-- IO_STATUS ------- *STATUS ----------------------------->
field name
>-- IO_ERROR -------- *ABORT ------------------------------>
*NEXT
*RETURN
label
>-- VAL_ERROR ------ *LASTDIS ------------------------------>
*NEXT
*RETURN
label
>-- NOT_FOUND --- *NEXT ---------------------------------->
*RETURN
label
>-- ISSUE_MSG ------ *NO ----------------------------------->
*YES
>-- WITH_RRN ------- *NONE -------------------------------->
>-- RETURN_RRN --- *NONE --------------------------------->
>-- CHECK_ONLY ---- *NO ------------------------------------>
*YES
>-- AUTOCOMMIT -- *FILEDEF ---------------------------------|
*YES
*NO