Page 1 of 1

Make Syncsort stop when it finds what I want.

PostPosted: Wed May 14, 2014 11:30 pm
by The Mean Farmer
When we answer questions about how accounts process in my shop we find and strip files to get down to only the account (or group of accounts) that are in question. To do this we use UDACS to go find use the record(s) from TAPE or DASD as we can stop it processing when it finds the condition in question. This saves lots of time for us and the CPU.

Example:

UDACS   VER=(27,EQ,16,C,'1234567890123456'),END=(27,GT,16,C,1234567890123456) 


The job will pull anything that will is = to account number 1234567890123456, and the instant it gets Greater Than that number account number the job will stop searching, and end processing.

Question is can Syncsort do something like this? My search of the SyncSort Manual shows the STOPAFT command, but that uses record counts, not conditional expressions.

Can Sort (or another utility) accomplish this like UDACS?

Re: Make Syncsort stop when it finds what I want.

PostPosted: Thu May 15, 2014 1:00 am
by dick scherrer
Hello,

Not that I am aware of.

Re: Make Syncsort stop when it finds what I want.

PostPosted: Thu May 15, 2014 2:44 am
by BillyBoyo
Nor me. Unless you know to within a reasonably small number of records how many there should be, when you could fudge it, perhaps. But no, you can't tell SyncSort to "stop" at/after a particular value, just by counts.

Re: Make Syncsort stop when it finds what I want.

PostPosted: Tue Jun 03, 2014 9:21 pm
by The Mean Farmer
Alissa, do you know any action within SyncSort to make this happen? We would LOVE to see this functionality at my shop.

Re: Make Syncsort stop when it finds what I want.

PostPosted: Tue Jun 03, 2014 11:30 pm
by BillyBoyo
If you register at SyncSort's website, you can ask the question there. Quicker than waiting...