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

Required to get the record based on the time stamp


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

New User


Joined: 07 Sep 2010
Posts: 22
Location: hyderabad

PostPosted: Fri Apr 03, 2015 4:33 pm
Reply with quote

Hello,

I have a input file like below.

15972014-12-17-14.10.00.000000
15972014-12-17-15.10.00.000000
15972014-12-18-14.10.28.000000
15002014-12-18-14.10.28.000000
15002014-12-18-14.10.20.000000
15002014-12-19-14.10.20.000000

Here 1-4 position is my key. Based on my key value, need to pull ONE record which is having latest time stamp.

Output file:
15972014-12-18-14.10.28.000000
15002014-12-19-14.10.20.000000


Please help me how to achieve this by using SORT
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 754
Location: Pennsylvania

PostPosted: Fri Apr 03, 2015 5:31 pm
Reply with quote

Step 1 - Sort on the entire date/timestamp descending

Step 2 - Sort on positions 1-4 descending using equals and sum fields=none

Check the manual for syntax if needed.
Back to top
View user's profile Send private message
somapradeep1

New User


Joined: 07 Sep 2010
Posts: 22
Location: hyderabad

PostPosted: Fri Apr 03, 2015 6:00 pm
Reply with quote

Running two steps on same data makes performance issue on huge data. So trying to make it in a single step
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 754
Location: Pennsylvania

PostPosted: Fri Apr 03, 2015 6:14 pm
Reply with quote

How huge are you taking? One million records, two million?

I do not know of anyway of doing it in a single step.

Good luck.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Fri Apr 03, 2015 7:07 pm
Reply with quote

Did you, by any slightest of a chance, make an effort to read the DFSORT manual?

This shouldn't take much time if you read WHEN=GROUP and use a KEYBEGIN (even if you are reading it for the first time).

Please Read the Manual, Try it and then post here what you tried and failed to get.

.
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
This topic is locked: you cannot edit posts or make replies. how to extract a portion (e.g. fields... SYNCSORT 8
This topic is locked: you cannot edit posts or make replies. Writng matched records into output fi... DFSORT/ICETOOL 11
No new posts Compare the file record count percent... DFSORT/ICETOOL 4
No new posts Record count of RECFM=U tape file DFSORT/ICETOOL 17
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