7.35 DELETE

Note: Usage options

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.1 DELETE Parameters

7.35.2 DELETE Comments / Warnings

7.35.3 DELETE Examples

                                                         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