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

Need help on ICETOOL


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

Active User


Joined: 22 Dec 2007
Posts: 126
Location: Bangalore

PostPosted: Tue Jan 20, 2015 4:02 pm
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: 199
Location: UK

PostPosted: Tue Jan 20, 2015 4:08 pm
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jan 20, 2015 5:42 pm
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

Active User


Joined: 22 Dec 2007
Posts: 126
Location: Bangalore

PostPosted: Tue Jan 20, 2015 6:04 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts ICETOOL to Read records SMF CEF it is... DFSORT/ICETOOL 4
Search our Forums:

Back to Top