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
 

 

use average command in icetool report generation method

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
janmejay
Warnings : 1

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Tue May 06, 2008 3:31 pm    Post subject: use average command in icetool report generation method
Reply with quote

Hi , by using icetool method i have generated the report , but i need to find out average of a partuculr field , like salary.
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue May 06, 2008 8:57 pm    Post subject:
Reply with quote

If you're using the DISPLAY operator of DFSORT's ICETOOL, you can use the AVERAGE('text') operand to display the average.

If that's not what you want, then give more details - show the ICETOOL statements you're using and an example of your input records and what you want for output.

You can find complete details of the DISPLAY operator at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.7?DT=20060615185603

You can find all of the DFSORT books at:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
janmejay
Warnings : 1

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Wed May 07, 2008 9:33 am    Post subject:
Reply with quote

By using average('text') , it displaying only the text. not showing average value of salary field.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed May 07, 2008 8:42 pm    Post subject:
Reply with quote

AVERAGE('text') will display the average for every numeric ON field. I suspect you're using CH as the format for the salary field instead of ZD. Change

ON(p,m,CH)

for the salary field to

ON(p,m,ZD)

where p is the starting position and m is the length, and you'll get the averge for that field. If you need help editing the ZD field to look a certain way, tell me the length of the ZD field and what you want it to look like in the report.

Remember when I said the following in my previous post:

Quote:
If that's not what you want, then give more details - show the ICETOOL statements you're using and an example of your input records and what you want for output.


If you had done what I asked, I wouldn't have to guess at what you have/want and we could be done by now.
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 Splitting of single report to seperat... abdulrafi TSO/ISPF 4 Mon Mar 27, 2017 3:59 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm


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