Remove particular records from Syncsort



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Re: syncsort

Postby meena » Thu Nov 24, 2011 10:53 am

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....
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort

Postby pjagathis » Thu Nov 24, 2011 12:38 pm

HI Meena..

Please post some example Input records and expected Output records... Also post your code and error message....
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort

Postby meena » Fri Nov 25, 2011 9:34 am

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
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort

Postby dick scherrer » Fri Nov 25, 2011 12:04 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Remove particular records from Syncsort

Postby meena » Mon Nov 28, 2011 5:31 pm

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.........
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Remove particular records from Syncsort

Postby dick scherrer » Tue Nov 29, 2011 10:05 am

Good to hear it is working - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post