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
 

 

Excluding the headers in the output file using file aid

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
sandy_venkat

New User


Joined: 16 May 2007
Posts: 35
Location: India

PostPosted: Tue Jan 22, 2008 12:33 pm    Post subject: Excluding the headers in the output file using file aid
Reply with quote

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 ( -----icon_cool.gif 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)
Back to top
View user's profile Send private message

sandy_venkat

New User


Joined: 16 May 2007
Posts: 35
Location: India

PostPosted: Tue Jan 22, 2008 2:46 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Jan 22, 2008 5:21 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
sandy_venkat

New User


Joined: 16 May 2007
Posts: 35
Location: India

PostPosted: Wed Jan 23, 2008 11:15 am    Post subject:
Reply with quote

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??
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 24, 2008 4:52 pm    Post subject:
Reply with quote

Thanks Sandy for posting your solution.. icon_smile.gif
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 -> Compuware & Other Tools 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 file using XMITIP abdulrafi TSO/ISPF 3 Mon Mar 27, 2017 3:01 pm
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm


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