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: 762
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: 762
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. SUM based on two conditions using SYN... SYNCSORT 7
No new posts using based or defined variables PL/I & Assembler 2
No new posts To pull the file with Date and Time u... TSO/ISPF 17
No new posts COBOL Table data to a flat file with ... COBOL Programming 8
No new posts Write a current record plus previous ... DFSORT/ICETOOL 4
Search our Forums:

Back to Top