Omit lines between Low and High range.



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Omit lines between Low and High range.

Postby polamjeevan » Fri Apr 09, 2010 6:52 pm

Hi
I need immediate help from you on removing the lines between Low and High values.
For example I have a dataset like
abc1254.01.12.37
abc1254.01.12.38
abc1254.01.12.39
abc1254.01.12.40
abc1254.01.13.13
abc1254.01.13.14
abc1254.01.13.15
abc1254.01.13.16
In this i want to delete the Lines between Low and High value.
The final o/p should be like
abc1254.01.12.37
abc1254.01.12.40
abc1254.01.13.13
abc1254.01.13.16
Please help me on this. Thankyou.
polamjeevan
 
Posts: 2
Joined: Fri Apr 09, 2010 5:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Omit lines between Low and High range.

Postby Frank Yaeger » Fri Apr 09, 2010 8:54 pm

How are you "grouping" the records? By positions 1-13, or some other way? How exactly?

What is the RECFM and LRECL of the input file?

Are the input records already in sorted order as shown in your example?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Omit lines between Low and High range.

Postby polamjeevan » Sun Apr 11, 2010 4:14 pm

No the records are not in sort order, i thought to apply the sort function before grouping records by position 1-16 chars
Input file of Recfm FB of length 80.
polamjeevan
 
Posts: 2
Joined: Fri Apr 09, 2010 5:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Omit lines between Low and High range.

Postby Frank Yaeger » Mon Apr 12, 2010 10:27 pm

i thought to apply the sort function before grouping records by position 1-16 chars


If you group the records by 1-16, then the low value would be:

abc1254.01.12.37

and the high value would be:

abc1254.01.13.16

but that's not what you show as the expected output. You need to do a better job of explaining the "rules" for getting from input to output before anyone can help you.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post