Excluding the headers in the output file using file aid

sandy_venkat · New User Joined: 16 May 2007 Posts: 35 Location: India

Hey guys,

Is it possible to exclude the headers in the output report and compare only data? I have a report as output. The format is something like this..

(header starts from here)

Run date: --- XXXX Report ------
Run time: --- --- --------
date ------
------ ------- --
-------
--------
----------
-----
-----------

(Data starts from here)

From the Run date to the final ( -----

are the headers. There are 9 lines of headers always. Then from the next line (record) i have the data starting...that can be 1 to a max of 45 lines. So a page can contain at max 54 lines(i.e 45 + 9 headers).

There are around 8.5 lac records that i get. I want to compare the prod run with my output. I want to run a compare but as the headers doesnt match (some contain date change, time change, etc) i want to exclude the headers and only compare the data.

This is one requirement..

As the prod version is quite old, the pic clause for a particular variable was given as 9(7) but now the variable can contain more than 7 digits. So i want to exclude the last column also.. (from cols 125 to 133).

Is this possible using File Aid or any other tool?

Summary: a) excluding the headers as i mentioned abv
b) excludin cols 125 to 133.

Could you guys please suggest me the way to solve this?
This pgm doesnt use DB2 (if that would help in anyway)

sandy_venkat · New User Joined: 16 May 2007 Posts: 35 Location: India

Hey guys,

I got the output i required....Just did it part by part...Used the unformatted option of the file aid copy option, f.3.3 and ran using all the conditions i required and i got it.

Anuj Dhawan · Posted: Tue Jan 22, 2008 5:21 pm

Thanks for sharing the solution Venkat. It would be great to complete this thread if you post a bit (or full if the code is not big enough) the code you uesd.

sandy_venkat · New User Joined: 16 May 2007 Posts: 35 Location: India

Hey anuj,

I used the copy utility of the file aid... f.3.3

I didnt code anything...Just in the unformatted option. i excluded the lines those i did not need....

E.g the first two headers had a term 'RUN'. So i gave the condition like,

Position, Length, RO Data Value
--------,- -----,-- ---- ----------
2 NE T'RUN'

The keyword RUN was in coln 1 in the report. But in file Aid one always gives (Coln+1). Hence 2.

Similarly i gave the other conditions till i got the output that i reuired.

Then for excludin gcolm, i tool that file in 3.13 and used the CMPCOLM 2:120 so that it checked only in those colms and not any colms b4 or after them.

In this fashion, i got the output.

Does anyone know why we use (Coln number + 1) in file aid??

Anuj Dhawan · Posted: Thu Jan 24, 2008 4:52 pm

Thanks Sandy for posting your solution..