File-AID - Is it possible to get the total of a column?

Barry Keogh · New User Joined: 14 Jan 2011 Posts: 6 Location: UK

Hi All

I am in file-aid examining a report. What i would like to do is get the total for a particular column, is this possible from within file-aid?

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

I think we can't do this using file Aid. FileAID is only for viewing and editing the data sets i feel.

PeterHolland · Posted: Fri Mar 25, 2011 3:25 pm

Use the TALLY function.

Jasand · Posted: Wed Apr 27, 2011 10:03 am

Peter,
I tried with TALLY for a VSAM file and was able to get the below o/p with record count, LRECL etc..
Can you please advice on how to get the TOTAL OF A PARTICULAR COLUMN ?
Is there any commands to be used with TALLY ? (specifying the column postion etc..)

Nic Clouston · Posted: Wed Apr 27, 2011 10:10 am

VSAM files do not have columns. DB2 tables have columns.

Jasand · Posted: Wed Apr 27, 2011 10:13 am

sorry Nic for the confusion.
I actually meant the positions.
Is it possible to specify the POSITIONS and perform COMPARE through TALLY ?

Thanks,
Jasand.

PeterHolland · Posted: Wed Apr 27, 2011 10:30 am

Its all in the manual :

File-AID/MVS Batch Reference Manual

$$DD01 TALLY IF=(10,EQ,C’90’),ACCUM=(16,’TOTALS 1990’),
IF=(6,EQ,C’08’),IF=(10,EQ,C’90’),ACCUM=(16,’AUGUST 1990’)

This example locates any record that has a value of 90 in locations 10 and 11, and
accumulates the packed field that begins in location 16. If locations 6 and 7 contain a
value of 08, File-AID takes a second accumulation. After execution, the resulting
accumulation totals are labeled TOTALS l990 and AUGUST 1990 when printed on the
SYSTOTAL dataset.

Jasand · Posted: Wed Apr 27, 2011 11:20 am

Thank you Peter

PeterHolland · Posted: Wed Apr 27, 2011 11:30 am

You are welcome.