View previous topic :: View next topic
|
Author |
Message |
Alks
New User
Joined: 14 Jan 2016 Posts: 9 Location: INDIA
|
|
|
|
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 |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
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 |
|
|
|