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

Need help in creating report


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

New User


Joined: 19 Mar 2009
Posts: 1
Location: chennai

PostPosted: Sun Nov 22, 2009 7:25 pm
Reply with quote

Hi All,


As i'm new to ICETOOL, I would like to sum up the amount individually(i.e. position 29-36) based upon the one Indicator(i.e. position 50) and display the same by using ICETOOL. Indicator will have the values of either Z or blank. If indicator is E, then i've to sum the charge amount of the input records which are having indicator as Z and same for blank also. In addition to that i've to display total amount irrespective of indicator.

I'm not able to create trailer records alone.

Current Code:
Code:

INREC FIELDS=(C'A',29,8,71X)
      SORT FIELDS=(1,1,CH,A)
      OUTFIL FNAMES=OUTDDXX,REMOVECC,
           NODETAIL,SECTIONS=(1,1,HEADER3=XX,
           TRAILER3=(5:C'$',6:TOT=(2,8,SFF,
                EDIT=(SIII,IIT.TT),SIGNS=(,-)),
            2/,5:'---------------------------------------------------',
            /,5:'---------------------------------------------------'))
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Nov 23, 2009 2:28 am
Reply with quote

Hello and welcome to the forum,

Please post some sample input and the output (including the trailer) you want from that input. Mention the "rules", the relevant data postiions, and the recfm and lrecl.
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 Creating Unix Directory using COBOL i... COBOL Programming 2
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
No new posts Report of batch jobs JCL & VSAM 1
Search our Forums:

Back to Top