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

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: 116
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: 197
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: 7312
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: 116
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 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 Hexadecimal Group compare and write t... DFSORT/ICETOOL 5
No new posts Splice multiple records into single r... DFSORT/ICETOOL 4
No new posts Using ICETOOL set return code as per ... DFSORT/ICETOOL 4
No new posts ICETOOL Sorting and Discarding DUPS SYNCSORT 11
No new posts ICETOOL - Finding keys within a file DFSORT/ICETOOL 10

Back to Top