# EDELETE

Updated: 11/30/2021, 7:00:45 PM
Created: 11/30/2021, 7:00:45 PM
Last Updated By: Jake Tuttle
Read Time: 1 minute(s)

Tags: jql

# Description

Deletes selected records from a file according to record list or selection criteria clauses. It takes the general form:

EDELETE file-specifier [record-list | selection-criteria]
1

EDELETE requires an implicit or explicit record list, or selection criteria. An implicit list can be provided by preceding the command with a SELECT, GET-LIST or other list-providing command.

EDELETE will immediately delete the specified records.

To clear all the records in a file, use the CLEAR-FILE command.

# Examples

:EDELETE SALES "ABC" "DEF"
2 Records deleted
1
2

Delete the records ABC and DEF based on the explicit list of records.

:EDELETE SALES IF P.CODE = "GHI]"
n Records deleted
1
2

Delete all records in the SALES file in which the P.CODE field starts with GHI.

:SELECT SALES WITH S.CODE = "ABC"
n Records selected
>EDELETE SALES
n Records deleted
1
2
3
4

Selects all records in the SALES file in which the S.CODE field contains ABC, and deletes them.

Back to jQL

Back to jQL Cross Reference