Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
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 in creating report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Need help in creating report
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

Site Director


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

PostPosted: Mon Nov 23, 2009 2:28 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Creating ISPF Screens with Scrname vi... Albireo20 TSO/ISPF 9 Tue Sep 05, 2017 4:24 pm
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us