Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can we Delete Record from the Sequential File

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
sakthmainframe
Currently Banned

New User


Joined: 22 Mar 2007
Posts: 2
Location: Chennai

PostPosted: Thu Mar 22, 2007 4:05 pm    Post subject: Can we Delete Record from the Sequential File
Reply with quote

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.
Back to top
View user's profile Send private message

baldi

New User


Joined: 16 Jun 2005
Posts: 13
Location: Amsterdam

PostPosted: Thu Mar 22, 2007 4:26 pm    Post subject:
Reply with quote

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!!
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Mar 22, 2007 4:36 pm    Post subject:
Reply with quote

baldi wrote:
sequential file s as easy as "d" in edit mode...... its too basic!!
Not to me, how?
Back to top
View user's profile Send private message
pcoreddy

New User


Joined: 14 Mar 2007
Posts: 24
Location: Mysore

PostPosted: Thu Mar 22, 2007 6:44 pm    Post subject: Re: Can we Delete Record from the Sequential File
Reply with quote

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
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Thu Mar 22, 2007 6:50 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Mar 22, 2007 6:56 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Thu Mar 22, 2007 8:28 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
vijayprabu

New User


Joined: 15 Dec 2005
Posts: 21

PostPosted: Tue Apr 24, 2007 5:11 pm    Post subject: Re: Can we Delete Record from the Sequential File
Reply with quote

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?
Back to top
View user's profile Send private message
rajesh_mbt

New User


Joined: 27 Mar 2006
Posts: 95
Location: India

PostPosted: Tue Apr 24, 2007 5:39 pm    Post subject: Re: Can we Delete Record from the Sequential File
Reply with quote

vijayprabu wrote:
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?


Hi Vijay
It cannot take space agian while updating the record in a file.
Also the updated record would be stored on the same place.
Please let me know something else
Back to top
View user's profile Send private message
nandu404

New User


Joined: 20 Sep 2006
Posts: 4

PostPosted: Wed Apr 25, 2007 3:43 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us