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 Usergroups 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 Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Creating an 'Enter' event with IMS MF... dileep chirasani Java & MQSeries 1 Sat Aug 06, 2016 2:23 am
No new posts Creating a dynamic sort card in JCL u... ChitraChhabra DFSORT/ICETOOL 4 Wed Aug 03, 2016 6:15 pm
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm


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