Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need help on ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
subratarec

New User


Joined: 22 Dec 2007
Posts: 73
Location: Bangalore

PostPosted: Tue Jan 20, 2015 4:02 pm    Post subject: Need help on ICETOOL
Reply with quote

Hi,

I have a requirement (desc given below).

Code:

MODEL  COLOR  SIZE  QTY WAREHOUSE
AAAAA  A      001    50   10
AAAAA  A      001    21   09
AAAAA  A      001    23   18
BBBBB  B      005    26   12
BBBBB  B      005    56   23
BBBBB  B      005    08   04
BBBBB  B      005    54   11


Now after SORT the SORTOUT file should contain something like this..

Code:

MODEL  COLOR  SIZE  QTY WAREHOUSE
AAAAA  A      001    94   37
BBBBB  B      005    144 50


Could someone plz help me on how shall I achieve this result using SORT/ICETOOL..?

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

David Robinson

Active User


Joined: 21 Dec 2011
Posts: 175
Location: UK

PostPosted: Tue Jan 20, 2015 4:08 pm    Post subject:
Reply with quote

What have you tried so far and what problems are you getting?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Tue Jan 20, 2015 5:42 pm    Post subject: Reply to: Need help on ICETOOL
Reply with quote

You can do it with either SORT or ICETOOL. Use the OUTFIL reporting functions for SORT (like HEADER1, SECTIONS with TRAILER3) or ICETOOL's DISPLAY operator.
Back to top
View user's profile Send private message
subratarec

New User


Joined: 22 Dec 2007
Posts: 73
Location: Bangalore

PostPosted: Tue Jan 20, 2015 6:04 pm    Post subject: Reply to: Need help on ICETOOL
Reply with quote

Hi Bill,

Thanks!! again for your help. Yes I going through the details of those options you have mentioned in reply. Hopefully I will be able to achieve the desired result. Will come back if I face any issue while coding..

Thanks
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Icetool or Joinkeys example to compar... ishant chauhan DFSORT/ICETOOL 21 Sat Aug 20, 2016 2:40 am
No new posts ICETOOL higher option Anshul Das DFSORT/ICETOOL 14 Thu Apr 14, 2016 8:00 am
No new posts Compare Files and extract matching re... vimalravi83 DFSORT/ICETOOL 3 Wed Jan 06, 2016 2:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us