eliminate low values and copy



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

eliminate low values and copy

Postby ranga_subham » Mon Sep 29, 2008 10:12 pm

Hi,

I have an input file with millions of records. I want to eliminate all the records that have low-values starting at position 379 (length is 6).

Please suggest a SORT card for this........

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

Re: eliminate low values and copy

 

Re: eliminate low values and copy

Postby Alissa Margulies » Mon Sep 29, 2008 10:45 pm

Try this:
//SYSIN DD *
  SORT FIELDS=COPY
  OMIT COND=(379,6,BI,EQ,6X'00')
/*

or you can specify
   OMIT COND=(379,6,BI,EQ,X'000000000000')
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: 1 time

Re: eliminate low values and copy

Postby ranga_subham » Tue Sep 30, 2008 4:35 pm

Alissa, Thank you very much........it worked....... :D
Bye.
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