Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Bill Woodger
1. "This manual left intentionally blank". Try a DATASORT. If you have that, you probably have everything. 2. Yes, symbols are great. SyncSORT doesn't call them symbols as such, I think they are "dictionary" or something like that. I've been known to change Kolusu's inline comments to

Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Bill Woodger
If you don't need the physical file for anything except to extract from it, you can just establish a SEQNUM for each selection, and just use an OUTFIL (or more) with your selection by number. Saves the SORT, the creation of the new file, and the processing of the new file, just cutting straight

Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Steve Smith
Just some general suggestions that may be helpful: 1. ICETOOL has a number of commands that may make it easier to do what you want. It's worth getting familiar with it. I've recently discovered that SYNCTOOL handles my ICETOOL jobs just fine. I've not seen a byte of doc on SYNCTOOL, so there

Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Farley, Peter x23353
Thanks Bill, that put me on the right track. Another regular poster also offered me some other options offline that might require fewer passes, which I am exploring. I will report back for the archives when I figure out what I am going to use. Peter -Original Message- From: IBM

Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Bill Woodger
Also, your initial BUILD creates the extra byte which is used. You can change the subsequent BUILDs to OVERLAY which just change the one byte at column 5: (will save you one BUILD per record, you'll notice). If 220k+ were really large, you could also (since the test values are mutually

Re: SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Bill Woodger
It doesn't matter where you physically locate the SORT control card, SORT will execute after INREC. You need to put anything which the SORT relies upon in INREC, and anything which relies upon the SORT in OUTREC. -- For

SYNCSORT SEQNUM not restarting at 1 or incrementing by 1 for changes in RESTART value

2017-04-24 Thread Farley, Peter x23353
I am trying to partition a fairly large RECFM=VB dataset (220K+ records) by various characteristics of the records using a unique identifier byte and a SEQNUM. The goal is to be able to subsequently extract in a second pass some "count" number of records by "type" to create an extracted sample