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
 

 

Copying a subset of records to new data set

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Mon Feb 27, 2012 11:38 pm    Post subject: Copying a subset of records to new data set
Reply with quote

I have a data set of approximately ten million records and what I would like to do is simply copy the first 500 records and the last 500 records to a new data set. I found a couple of posts where this was easily done with ICETOOL but in checking with our mainframe support people they say ICETOOL is not on our system. I have considered SYNCSORT which has the INCLUDE/OMIT statements but then how would I refer to the sequence or position of the records in the file? What I want is an equivalent of the HEAD and TAIL commands in UNIX.


Charles Wolters
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10278
Location: italy

PostPosted: Mon Feb 27, 2012 11:56 pm    Post subject: Reply to: Copying a subset of records to new data set
Reply with quote

odd installation,
whatever the sort product ICETOOL and SYNCTOOL are there

but if on the other side ICETOOL/SYNCTOOL is frowned upon that' s a completely different can of worms
( who - the worms - got fat by eating the neurons of the person who dictated the stupid rule )
Back to top
View user's profile Send private message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Tue Feb 28, 2012 2:13 am    Post subject: RE:Copying a subset of records
Reply with quote

Enrico,

It will take me a few minutes to put together a program using ICETOOL.I will submit it and if you are correct in your assertion then I guess our mainframe technical support group will need to attend re-education camp.

Charles Wolters
Back to top
View user's profile Send private message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Tue Feb 28, 2012 7:20 pm    Post subject: RE: Copying a subset of records to disk
Reply with quote

Yep. ICETOOL was there. I used some code posted by Frank Yaeger a few years ago and all is good.

Charles Wolters
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Feb 28, 2012 7:32 pm    Post subject:
Reply with quote

Actually, as Enrico has pointed out - at Sync-Sort shops, ICETOOL is aliased to SYNCTOOL. If you look at the SYSOUT of your Job, you'll find SYNCTOOL for Sync-Sort is invoked under the covers. (SYTxxx messages)

Saying, "ICETOOL was there" is subjective, because ICETOOL have it's official documentation and support available while for SYNCTOOL it is not.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Feb 29, 2012 12:58 am    Post subject:
Reply with quote

If the messages in DFSMSG start with ICE, you are using DFSORT's ICETOOL.

If the messages in DFSMSG start with SYT, you are using Syncsort's SYNCTOOL.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 2 Fri Jul 28, 2017 9:10 pm
No new posts Paasing symbolic parameter to instrea... Robert Sample JCL & VSAM 2 Thu Jul 27, 2017 1:22 pm
No new posts Passing data from REXX to C programme... chong.zhou CLIST & REXX 3 Wed Jul 26, 2017 9:11 pm
No new posts copying data without knowing location Arun Raj DFSORT/ICETOOL 12 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm


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