MVSFORUMS.com

Anand_R · Intermediate Joined: 24 Dec 2002 Posts: 189 Topics: 60

Hi everyone,

I have 2 files of LREC = 3000. I want to compare the first record in first file with first record in 2nd file. Then write the changed(modified) data in the output file(If any). Is it possible by any sort utility.

Example

Input File 1:

12345ABCDEFGfalse.

Input File 2:

12345ABCEDFGtrue.

Output file :

ABCEDFGtrue.

(first 5 bytes should be spaces.. as there was no data change).. I want out put also in the same format as input(But only modified data in the output)

Please let me know if I am not clear enough...

Actually my input file is very big enough(3000 bytes).

Thanks
Anand

Cogito-Ergo-Sum · Posted: Thu Nov 13, 2003 2:27 pm Post subject:

I think, ISRSUPC (=3.13) is a better option here.

Nevertheless, what would you do if the number of records in the datasets are unequal?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

kolusu · Posted: Thu Nov 13, 2003 2:59 pm Post subject:

Anand,

A couple of questions. Do you want to compare each and every byte of lrecl 3000? Do you have a key to compare?

The hardest part would getting only the differences(modified data) in the output record.

Do you have easytrieve at your shop?

cogito: Superc is not ideal tool for comparing files with lrecl greater than 250.

Hope this helps...

cheers

kolusu

Anand_R · Intermediate Joined: 24 Dec 2002 Posts: 189 Topics: 60

Kolusu,

Thanks for your reply... I have to compare each and every byte. And I have easy treive in my shop..

Thanks
Anand

Cogito-Ergo-Sum · Posted: Thu Nov 13, 2003 3:24 pm Post subject:

Why is it so, Kolusu?

I quickly skimmed the manual. But, I do not see this written explicitly anywhere.
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

kolusu · Posted: Thu Nov 13, 2003 4:27 pm Post subject:

Anand,

The following JCl will give you the desired results.A brief explanation of the Job. The jobs reads in both the files and then takes each record from both the files and compares it against each and every byte in both records. If they differ then we write it out to the output record.

Anand_R · Intermediate Joined: 24 Dec 2002 Posts: 189 Topics: 60

Kolusu,

Actually my input file have all types of data(char, integer, & comp).. Does ur solution work in that case?

Thanks
Anand

kolusu · Posted: Fri Nov 14, 2003 3:34 pm Post subject:

Anand,

Why don't your test it for yourself and let me know if it works for the scenario you mentioned?

Thanks

Kolusu

raveendra_ibm · Beginner Joined: 02 Apr 2006 Posts: 32 Topics: 10

Hi Kolusu !

Refering the code above, Is the comparision based on a key ?
How different is it from File - Aid ? Could you please explain.

Thanks and Regards,
Raveendra.

kolusu · Posted: Thu Apr 06, 2006 12:01 pm Post subject:

raveendra_ibm · Beginner Joined: 02 Apr 2006 Posts: 32 Topics: 10

Hi Kolusu,

Sorry...... missed that.

Thanks,
Raveendra.