View previous topic :: View next topic
|
Author |
Message |
Charles Wolters
New User
Joined: 30 Mar 2011 Posts: 48 Location: United States
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
Charles Wolters
New User
Joined: 30 Mar 2011 Posts: 48 Location: United States
|
|
|
|
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 |
|
|
Charles Wolters
New User
Joined: 30 Mar 2011 Posts: 48 Location: United States
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
|