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

Sort records based on numeric field.


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Alks

New User


Joined: 14 Jan 2016
Posts: 9
Location: INDIA

PostPosted: Wed Oct 19, 2016 10:14 pm
Reply with quote

Hi,
I have a requirement where I have to sort the records based on the date difference.

Code:
ABC 20161019  20160210  +0000252
DEF 20161019  20160216  +0000246
GHI 20161019  20160213  +0000249


Date difference in HEX form is as below:
Code:
+0000252
4FFFFFFF
E0000252


I need to filter only those records, for which date differenece is say greater than or equal to +0000248

This is what I tried including some other modifications such as using ZD.
Code:
SORT FIELDS=COPY                   
INCLUDE COND=(25,8,PD,GE,+0000248)


But it's just including all the records.

Any help would be really appreciated.

Code'd
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Wed Oct 19, 2016 10:53 pm
Reply with quote

Your data is NOT PACKED.

Since, you didn't use code tags, the spaces between fields were not preserved.

You can use ZD and compare like:
Code:
 OPTION COPY
 INCLUDE COND=(26,7,ZD,GE,248)

Or you can use FS like:
Code:
 OPTION COPY
 INCLUDE COND=(25,8,FS,GE,+0000248)   

Or you could also use SFF like:
Code:
 OPTION COPY
 INCLUDE COND=(23,8,SFF,GE,+0000248) 

.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Wed Oct 19, 2016 11:07 pm
Reply with quote

Please learn to use appropriate BBCodes during your next post,If you are a Beginner to DFSORT then , please join IBM MAINFRAME & MVS FORUM
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 -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Date conversion using SORT SYNCSORT 4
No new posts Merging more than two records DFSORT/ICETOOL 15
No new posts Matching and non matching records usi... DFSORT/ICETOOL 11
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
This topic is locked: you cannot edit posts or make replies. Is there a way to restrict user login... All Other Mainframe Topics 11
Search our Forums:

Back to Top