Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

EDELETE

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]


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 

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


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

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

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


Back to JQL

Was this article helpful?