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.