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
 

 

How to delete the record in the dataset -CLIST

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
svrekha

New User


Joined: 08 Mar 2007
Posts: 6
Location: coimbatore

PostPosted: Thu Nov 20, 2008 12:22 am    Post subject: How to delete the record in the dataset -CLIST
Reply with quote

Hi!
I given a input in the panel , if those values exist in the dataset, it should delete the record ,,,
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Thu Nov 20, 2008 12:41 am    Post subject: Reply to: How to delete the record in the dataset -CLIST
Reply with quote

svrekha, your profile lists you as a "software engineer", so I would think you'd already be familiar with sequential dataset processing.

You can't delete records from a sequential dataset. All you can do is copy all of the records you want to keep to a new dataset, skip the one you wish to delete, and create the new dataset. Then, if desired, delete or rename the current dataset and copy the contents of the new dataset into the existing dataset. Obviously, it would be beneficial for you to not write your own process, but rather use an existing utility for this.

Other than that standard process, the only other way to remove a record from a sequential dataset is by editing it. Edit it, find the record, delete the record, then save it.
Back to top
View user's profile Send private message
svrekha

New User


Joined: 08 Mar 2007
Posts: 6
Location: coimbatore

PostPosted: Thu Nov 20, 2008 12:56 am    Post subject:
Reply with quote

Thanks a lot kevin,,, i tried giving the same , but not working and also some clist commands am not sure,,, I you give some sample examples it will be really helpful...
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Thu Nov 20, 2008 1:19 am    Post subject: Reply to: How to delete the record in the dataset -CLIST
Reply with quote

I don't know CLIST (not too many people use it anymore) but if you describe your process in detail I might be able to hobble together some code.
Back to top
View user's profile Send private message
svrekha

New User


Joined: 08 Mar 2007
Posts: 6
Location: coimbatore

PostPosted: Thu Nov 20, 2008 2:11 am    Post subject:
Reply with quote

Am giving the an input in the screen ,,,, it should check whether the input given in the screen is equal to the record in the dataset ,, if yes , it should delete /skip the record ,,,,
It checks till the EOF , if found it will delete ....
Please let me know if you need any details
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2038
Location: Silicon Valley

PostPosted: Thu Nov 20, 2008 2:47 am    Post subject: Reply to: How to delete the record in the dataset -CLIST
Reply with quote

I think you can probably use DFSORT to exclude records. That is, make a new dataset without the records that you do not like.
Back to top
View user's profile Send private message
svrekha

New User


Joined: 08 Mar 2007
Posts: 6
Location: coimbatore

PostPosted: Thu Nov 20, 2008 7:25 am    Post subject: Reply to: How to delete the record in the dataset -CLIST
Reply with quote

but i need in clist....
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2038
Location: Silicon Valley

PostPosted: Thu Nov 20, 2008 10:09 am    Post subject: Reply to: How to delete the record in the dataset -CLIST
Reply with quote

Call DFSORT from your clist. (actually, rexx is preferred).

And especially, call DFSORT if you are talking about a lot of 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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


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