IFTHEN clauses execution order



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

Re: IFTHEN clauses execution order

Postby dick scherrer » Mon Aug 20, 2012 7:43 pm

Hello,

And I don't think using EXEC PGM=SYNCSORT or EXEC PGM=SYNCTOOL will make any difference because SYNCTOOL internally invokes SYNCSORT.
No, it should not make a difference. I only mentioned it because this system is "bent" a bit. Unless/until there is a need to get the Syetem Support people involved, i suspect we will use SORT instead of TOOL.

150 million is a fair number of records and i'd suggest running a timing test of the way the works correctly versus the incorrect answers that do not have the proper HIT=NEXTs. Yes, doing it so that it works may take some more cpu time, but probably not enough to be alarming. . . And you will have the needed results.
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: IFTHEN clauses execution order

Postby mfrookie » Tue Aug 21, 2012 11:13 am

Thanks Dick & Bill for your inputs.

I will definitely run a test to see the impact of more IFTHEN conditions. As far as possibility of avoiding WHEN=ANY is concerned, yes I can put the HIT=NEXT clause on the main IFTHEN clauses and then repeat the same condition so that I can put anything what I wanted to put in WHEN=ANY. For my case the fields that I am using in IFTHEN tests remain unimpacted by the IFTHEN processing (BUILD/OVERLAY). This will definitely reduce the number of tests that the record will go thru. But as you said it all depends on how much extra time is takes.

Its just that apart from this, in general I wanted to know more about WHEN=ANY clause execution.

Maybe Alissa can reply if she sees this thread.

Thanks.
mfrookie
 
Posts: 40
Joined: Mon Apr 25, 2011 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: IFTHEN clauses execution order

Postby BillyBoyo » Tue Aug 21, 2012 2:11 pm

As I said, I think you have discovered yourself how WHEN=ANY works.

Maybe we'll find out why it works that way :-)

If you do the INREC followed by OUTREC that I suggested, you'd not need HIT=NEXT. However, without seeing your cards, don't know if this is possible in your case...
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post