Can't you use NE in an include statement?



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

Can't you use NE in an include statement?

Postby iebfr14 » Fri Sep 19, 2008 8:48 pm

In the code below I assumed the NE would screen out the records with the values 176 and 286. However it included them in the output along with all the records that did not have the 176 and 286 value I intended to exclude. I got the desired results by switching to an OMIT and using EQ to screen out the undesired records but wanted to know why the NE in the include statement did not work.

INCLUDE COND=(44,3,CH,NE,C'176',OR,44,3,CH,NE,C'286',OR,
01,1,CH,EQ,C'T') This still included records with the 176 and 286 values even though the NE for them was coded.


omit COND=(44,3,CH,EQ,C'176',OR,44,3,CH,EQ,C'286') this did screen out the undesired recs.
iebfr14
 
Posts: 1
Joined: Fri Sep 19, 2008 12:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Can't you use NE in an include statement?

Postby Alissa Margulies » Fri Sep 19, 2008 9:21 pm

In the INCLUDE statement, change the OR to an AND between the first 2 conditions. That should give you the desired results.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post