ER Delete Records

ER [n] Eliminate Records. n records, beginning with the second record displayed, are deleted.

n Number of records to be deleted. Standard: n = 1.

The character '$' instead of a number n indicates the highest possible number 99999

Standard: n = 1.

ER key1-key2 All records with keys smaller than or equal to key2 are deleted, beginning with key1. The key may be specified in any one of the following ways: string | [C] 'string' | X'string'. The keys key1 and key2 do not have to be specified in their entirety. Only the unique portion of the required start and end keys needs to be specified. In this case, key1 will be padded to the right with low values (X'00') and key2 with high values (X'FF').

Examples:

ER

The second record in the display is deleted.

ER 999

999 records are deleted, beginning with the second record displayed.

ER 0003-01

All records whose key lies in the range between '0003*' and '01*' are deleted. * here represents a wildcard character to the end of the key.

ER X'AF'-X'AF'

All records whose key begins with X'AF' are deleted.