Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need help in grouping

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
raja_sekaran

New User


Joined: 06 Nov 2006
Posts: 1

PostPosted: Fri Oct 01, 2010 3:22 pm    Post subject: Need help in grouping
Reply with quote

The input file looks like below

AB123 2010-08-04-03.00.43.399514
AB123 2010-09-22-08.22.49.706437
BC123 2010-07-29-08.08.24.889041
BC123 2010-08-03-01.50.47.354343
CD123 2010-07-08-08.14.44.249383
CD123 2010-08-03-01.50.43.142728
DE123 2010-09-22-08.21.34.866570
DE123 2010-09-22-08.22.58.124082

The output will be the account which have the lower time stamp first

Expected output...

The input file looks like below

CD123 2010-07-08-08.14.44.249383
CD123 2010-08-03-01.50.43.142728
BC123 2010-07-29-08.08.24.889041
BC123 2010-08-03-01.50.47.354343
AB123 2010-08-04-03.00.43.399514
AB123 2010-09-22-08.22.49.706437
DE123 2010-09-22-08.21.34.866570
DE123 2010-09-22-08.22.58.124082


Thanks in advance
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 01, 2010 3:40 pm    Post subject:
Reply with quote

I believe that rather a lot more information is required than you have given here.

Sort product and release level being used.
DSORG, RECFM and LRECL of the input / output files.
What are the rules for getting from input to output.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Grouping of records trushant.w DFSORT/ICETOOL 8 Mon Jan 20, 2014 12:16 pm
No new posts Inserting new records based on grouping mohitsaini DFSORT/ICETOOL 1 Thu Sep 19, 2013 5:03 pm
No new posts Grouping records by a date ojdiaz DFSORT/ICETOOL 6 Thu Aug 23, 2012 2:24 pm
No new posts Inconsitent grouping when using Sum, ... GuyC DB2 1 Wed Jun 08, 2011 8:15 pm
No new posts Help needed on grouping and filtering... veeramanimurugesan DFSORT/ICETOOL 7 Thu Sep 02, 2010 10:27 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us