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 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: 78
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: 182
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: 7314

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: 78
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 ICETOOL - RESIZE DYNAMICALLY kranthikumarb DFSORT/ICETOOL 0 Tue Nov 21, 2017 5:30 pm
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am

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