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

DFSORT OUTFIL, ICETOOL DISPLAY


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
selvaganesan

New User


Joined: 21 Oct 2005
Posts: 5
Location: USA

PostPosted: Fri Oct 03, 2014 3:10 am
Reply with quote

Hi , Please clarify that the following is possible in DFSORT/ICETOOL.

Input

Field1 Field2 Amt
R1 C1 88.00
R2 C3 -87.30
R1 C2 -88.00
R3 C3 81.20
R4 C3 77.31
R2 C4 87.30
R3 C4 -08.20
R4 C4 -07.21

Output (Print records if receipt total is 00.00)
Field1 Field2 Total
R1 C1 88.00
R1 C2 -88.00
R2 C3 -87.30
R2 C4 87.30

I understand there is a TRAILER option in outfil. But is it possible to apply filter on TRAILER totals ..
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2637
Location: NYC,USA

PostPosted: Fri Oct 03, 2014 3:28 am
Reply with quote

Easy way is to take a help of this post and modify to include only those record which are having sum '0.00' and get rid off the count and header business.

ibmmainframes.com/about57122.html
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


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

PostPosted: Fri Oct 03, 2014 4:35 am
Reply with quote

So the first field is your key, the second is irrelevant, and you want to print all records for a key where the total for that key is zero?

Sounds like JOINKEYS, same input DSN for both legs, SORT in both, SUM in JNF2CNTL, OUTFIL INCLUDE= for the zero-sum values. Make the report look nice.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts SYNCSORT/ICETOOL JOINKEYS SORT Statem... DFSORT/ICETOOL 13
This topic is locked: you cannot edit posts or make replies. ICETool reporting 2 das old dataset DFSORT/ICETOOL 13
No new posts SOC7 error with DFSORT DFSORT/ICETOOL 9
No new posts How can we simulate JOINKEYS in ICETOOL DFSORT/ICETOOL 9
No new posts Converting a file from PD to display ... SYNCSORT 4
Search our Forums:

Back to Top