deleting a record in a sequential file

bala-lakshmi · New User Joined: 01 Mar 2004 Posts: 6

hai friends,
please tell me how to delete a particular record from a sequential file .organization is sequential,access mode is sequential
bye
lakshmi

anuradha · Posted: Tue Mar 16, 2004 4:46 pm

hi lakshmi,

In a sequential file we cant delete any record directly.AFAIK read the file until that particular record is found and delete it.That is the only way i hope.

THANKS AND REGARDS
ANU

bala-lakshmi · New User Joined: 01 Mar 2004 Posts: 6

HAI ANU,
WE CAN NEVER DELETE A RECORD FROM A SEQUENTIAL FILE.
BUT SUPPOSE I DON'T WANT A RECORD SAY IF I HAVE 10 RECORDS
I DON'T WANT THE 7 RECORD THEN HOW WILL I DELETE ?
PLEASE TELL ME WITH A PROGRAM
BYE

LAKSHMI

bluebird · Active User Joined: 03 Feb 2004 Posts: 127

hello,
the only way I can think of :
prepare a pgm that will have your seq file as input and a new temporary file (coded &&file with disp=(new,pass)) in your JCL
pgm will read and copy records you want in your temporary file
subsequent steps will 1 delete your seq file then recreate your seq file from temp file.

hope it helps

sandip_datta · Posted: Wed Mar 24, 2004 12:33 pm

In addition to bluebird's post,
We can use SORT with SKIP option to copy records selectively, provided the skip conditions are not that much complex.

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Hi lakshmi,

Your question should have been addressed in the design phase of the project.

If the file contained a "delete byte" that is turned "on" when the record is "deleted", you accomplish your objective. If space becomes a problem you can use SORT to recreate the file, dropping the "deleted" recs.

Regards, Jack.

kappurajesh · New User Joined: 03 Apr 2004 Posts: 4 Location: India

We can delete 7th record for that we have to create two sequential files with same structure , if count the records, if it is 7th , don't write to second seq. file else write it. And transfer to first seq file