IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

how to extract first and last records using sort


 
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srinivasulu.p

New User


Joined: 10 Jul 2012
Posts: 22
Location: india

PostPosted: Tue Jan 21, 2014 3:12 pm
Reply with quote

Hi please help me how extract 1st and last records from group of transactions
please find my sample file data.

Code:
 
2013-12-14    03.15.44    Y                       0    2013-12-13    CA
2013-01-25    23.57.12    Y                       0    2013-01-25     
2013-02-25    23.29.19    Y                       0    2013-02-25     
2013-03-25    23.29.18    Y                       0    2013-03-25     
2013-04-25    23.47.45    Y                       0    2013-04-25     
2013-05-24    23.13.08    Y                       0    2013-05-24     
2013-06-25    23.23.53    Y                       0    2013-06-25     
2013-07-30    23.12.41    Y                       0    2013-07-30     
2013-08-23    23.01.14    Y                       0    2013-08-23     
2013-09-25    23.19.20    Y                       0    2013-09-25     
2013-10-26    00.52.03    Y                       0    2013-10-25     
2013-11-26    00.53.15    Y                       0    2013-11-25     
2013-12-11    23.25.07    Y                       0    2013-12-11     
2013-01-18    23.06.48    Y                       0    2013-01-18
Back to top
View user's profile Send private message
sureshpathi10

Active User


Joined: 03 May 2010
Posts: 154
Location: Kuala Lumpur

PostPosted: Tue Jan 21, 2014 3:40 pm
Reply with quote

Hi,

Please refer to here for your requirement.

Please do search before post a new topic.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1566
Location: Andromeda Galaxy

PostPosted: Tue Jan 21, 2014 5:45 pm
Reply with quote

srinivasulu.p,

What is the sort product you use?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> JCL & VSAM
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Inserting records into the empty segm... IMS DB/DC 0
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts Combining more 4 files with sorted or... DFSORT/ICETOOL 3
No new posts JCL to extract repeating records DFSORT/ICETOOL 6

Back to Top