Compare two files in File AID.

kapiltamrakar · New User Joined: 24 May 2009 Posts: 41 Location: Hyderabad

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.

Nic Clouston · Posted: Fri Mar 25, 2011 3:25 pm

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

kapiltamrakar · New User Joined: 24 May 2009 Posts: 41 Location: Hyderabad

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

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...

Regards,
Kapil.

satyapn9 · New User Joined: 08 Oct 2010 Posts: 27 Location: India

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

.

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.