Page 2 of 2

Re: syncsort

PostPosted: Thu Nov 24, 2011 10:53 am
by meena
hi all,
i done with syncsort..thank you all for ur timely help... i have one ques.. i just want to know whether any other utility does the same except icetool....

Re: syncsort

PostPosted: Thu Nov 24, 2011 12:38 pm
by pjagathis
HI Meena..

Please post some example Input records and expected Output records... Also post your code and error message....

Re: syncsort

PostPosted: Fri Nov 25, 2011 9:34 am
by meena
hi all,
i did the code in single step by sort and also by syncsort.....i have one more ques... can we delete bunch of records based on the inserted sequence no.. i mean from 5000 to 6000 like that......
kindly suggest

Re: syncsort

PostPosted: Fri Nov 25, 2011 12:04 pm
by dick scherrer
Hello,

All you are willing to post is that "it didn't work". How can anyone helo if you do not provide sufficient info to resolve your problem(s)?

From the little you have provided, i suspect you can do all you want with Syncsort. You just need to follow wuggestions we make and post the jcl, control statements, and any diagnostic/informational info generated by the run. Each of these should be posted for each run you want to understand something that did not work or did not work as desired.

What happened when you tried the suggestion i mentoined earlier? If you haven't bothered t odo so - DO THIS NOW and let us know what happens.

For something as trivial as the first step in my suggestion, there is no good reason to fight for a one-step alternative.

can we delete bunch of records based on the inserted sequence no.. i mean from 5000 to 6000 like that......
How might it NOT be possible? Did you even try? Hint: consider using 2 variables for your compare.

Re: Remove particular records from Syncsort

PostPosted: Mon Nov 28, 2011 5:31 pm
by meena
hi dick,
i used gt and lt options in sequence no to delete the bunch of recorsds...
i used the outfil fnames=sortout,omit=condneeeded....
previously i was not aware of this outfil option......
i tried that and got.........

Re: Remove particular records from Syncsort

PostPosted: Tue Nov 29, 2011 10:05 am
by dick scherrer
Good to hear it is working - thank you for letting us know :)

d