Can we Delete Record from the Sequential File

sakthmainframe · New User Joined: 22 Mar 2007 Posts: 2 Location: Chennai

Can we Delete a Record from the Sequential File?

Can we delete a Record from KSDS file? What are the options available in KSDS,RRDS,ESDS.

baldi · New User Joined: 16 Jun 2005 Posts: 13 Location: Amsterdam

Yes you can delete records from all these files.. sequential file s as easy as "d" in edit mode.. for rest take a nice manual.. its too basic!!

William Thompson · Posted: Thu Mar 22, 2007 4:36 pm

pcoreddy · New User Joined: 14 Mar 2007 Posts: 24 Location: Mysore

i think we can delete records in KSDS and RRDS by using delete command

delete command u can use directly in the program

in case of ESDS file at my knowledge we cannt delete record

but which record u want delete ,for that record we can move the spaces to that perticular record

if anything is wrong pls correct me

kgumraj · Posted: Thu Mar 22, 2007 6:50 pm

Hi,

KSDS and RRDS the records can be deleted and that space can be utalised further.
ESDS you can delect the record but the space is lost for ever.

expat · Posted: Thu Mar 22, 2007 6:56 pm

I believe with a KSDS that the record is only flagged as deleted, and the space used by that record will not become available until the file is reorganised.

prav_06 · Posted: Thu Mar 22, 2007 8:28 pm

Hi All,
We cannot delete records from a sequential file Programmatically, but logically it can be done by moving spaces to that particular record, and yes the record can be deleted from the file if we open the file in a edit mode and giving a 'D' for that record.

Thamilzan.

vijayprabu · New User Joined: 15 Dec 2005 Posts: 21

What about updating the ESDS file? What will happen if i update a record from ESDS record? Physically will it stored in same place or some other place?

Because When you deleting the ESDS record you can't use that place further. But i really doubt about UPDATE ESDS record?

rajesh_mbt · New User Joined: 27 Mar 2006 Posts: 97 Location: India

nandu404 · New User Joined: 20 Sep 2006 Posts: 4

Hi,

You cannot physically delete a record from an ESDS and for that matter RRDS. Instead, most applications utilize a "logical delete" where a field in the ESDS record is set to a value indicating the record is no longer valid.

Unlike an ESDS or RRDS, deleted KSDS records are physically removed and the space is reclaimed.

And from a sequential file you can always delete records.