IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Compare two files in File AID.


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kapiltamrakar

New User


Joined: 24 May 2009
Posts: 41
Location: Hyderabad

PostPosted: Fri Mar 25, 2011 1:39 pm
Reply with quote

Hi all,
I am having a Requirement.
we have two files.

File 1 is having Having following record layout.
01 ws1-a-b
05 ...
05 ...
05 ...
05 sub-ws1 pix X(5).
05 ...
05 ...
01 ws1a-b-c
05 ...
05 ...

In file 2 we are changing the length of sub-ws to 7, which is shown below.

01 ws1-a-b
05 ...
05 ...
05 ...
05 sub-ws2 pix X(7).
05 ...
05 ...
01 ws2a-b-c
05 ...
05 ...

After writting file 2 from file 1, i want to compare both and show that the change is in only sub-ws variable, and i want to show this for all the records in both the file.

I thought for excluding certain positions in comparision using file Aid but above length change can be present in 3-4 places. so that will not work.

Please Help.
Regards,
Kapil.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Mar 25, 2011 3:25 pm
Reply with quote

In future you should post your FileAid queries in the Compuware section as it is their product, not CA's.

You are only showing one change to record length - are some of the fields between th 01 level and the field you are changing of variable length?

It is PIC not PIX
Back to top
View user's profile Send private message
kapiltamrakar

New User


Joined: 24 May 2009
Posts: 41
Location: Hyderabad

PostPosted: Mon Mar 28, 2011 12:14 pm
Reply with quote

Hi Nic,
Thanks for replying. I will take care for posting related queries in Compuware section. Thanks for bringing this in my notice too.. icon_smile.gif

No, There are not any variable length fields there.

I have got the answer for my query. I am using File Aid compare , with sorted approach ignoring the columns which are not needed to compare.

Thanks for your attention... icon_smile.gif

Regards,
Kapil.
Back to top
View user's profile Send private message
satyapn9

New User


Joined: 08 Oct 2010
Posts: 27
Location: India

PostPosted: Mon Mar 28, 2011 6:34 pm
Reply with quote

Hi Kapil,

How are you? This is Satya Prasad Nimmakayala, hope you have remembered me as we met in the training sessions of batch 753-754 in STC icon_smile.gif .

I hope all you need is the Comparision between two files using File-AID.
We had the code for this to compare two files. I am pasting it here.

The below statement we had in one Cntl Card
$$DD01 COMPARE
and compare options in another CNTL card. Attached this one. and also attached the output statestics.

Please check if this helps you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top