7.26 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.26.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