IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sortout data of specific range


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Thu Jul 26, 2012 4:14 pm
Reply with quote

Hi

I have a file with data say.

200001
100009
200005
200013
215000
213000
200000
310000

i want my output should contain which fall in range

2000005 to 213000 and need to be sorted.
others need to be excluded

Please help.

Thanks
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Thu Jul 26, 2012 4:47 pm
Reply with quote

I am sorry your requirement was not very clear to me atleast

Are you talking about the record range or are you talking about the value range ?

Also

Based on my above doubt

Do you want output

as

Code:

200005
200013
213000
215000


OR

Code:

200005
200013
213000


OR

Code:

200005
sort only the records between this value range
213000


OR

Code:

200005
sort only the records between this data range
213000
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 26, 2012 7:07 pm
Reply with quote

Hello,

In your SORT control, either INCLUDE the value range you want or OMIT the values (outside the range) you do not want.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
No new posts WER247A SORTOUT HAS INCOMPATIBLE LRECL SYNCSORT 7
No new posts Store the data for fixed length COBOL Programming 1
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
Search our Forums:

Back to Top