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: 2637
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 SYNCSORT/ICETOOL JOINKEYS SORT Statem... DFSORT/ICETOOL 13
No new posts Installing sort utilities on hercules... DFSORT/ICETOOL 4
No new posts How to read unpacked field created in... DFSORT/ICETOOL 12
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts Syncsort- Merging two records into on... SYNCSORT 3
Search our Forums:

Back to Top