Include cond for "between" values !



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

Include cond for "between" values !

Postby ranga_subham » Mon May 11, 2009 7:01 pm

Hi, I want to use INCLUDE condition to write output records falling between values '2' & '7'.

Input File:
0 110011
1 101010
2 209845
3 108756
4 018704
5 100100
6 900650
7 900450
8 100101


Output:
3 108756
4 018704
5 100100
6 900650


Please help.

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Include cond for "between" values !

Postby Alissa Margulies » Mon May 11, 2009 8:37 pm

Try this:

//SYSIN DD *
  SORT FIELDS=COPY
  INCLUDE COND=(1,1,CH,GT,C'2',AND,1,1,CH,LT,C'7')
/*
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

Re: Include cond for "between" values !

Postby ranga_subham » Tue May 12, 2009 3:02 pm

Thank you very much.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post