+2 votes

1 Answer

0 votes
by

The DBDEL command deletes an LREC from a subfile , Can delete the current LREC , LREC(s) with matching KEYn combinations also can delete by supplying a LRECNBR or a LRECNBR and KEYn combination , By default deletes current LREC

Mandatory Parameters for DBDEL

REF= | FILE=  (or both)

Optional parameters for DBDEL

ALG= | ORD = | FADDR = , SUFFIX=

         REG=

        UP|DOWN|NOORG

KEYn(R=,S=|D=|M=,L=,C=.UP|DOWN|NOORG) (n=1..6)

ERROR|ERRORA

LRECNBR

BEGIN

BEGIN : Starts from the beginning of the subfile before searching for LRECS to delete

ALL

ALL: All LRECS in the subfile will be deleted if specified , When used with the KEYn parameters deletes all matching records , If ALL records of subfile is deleted if the prime is a pool record then all the prime and overflow files will be released back to the system , If prime is fixed , it is filed to DASD and its overflows are released

...