Comparision using superC or File Aid record wise,

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

The requirement is to compare two files. The first record of the file (columns to compared 1-83,lRECL 91) has to be compared with all the records of second file (same columns to be compared, LRECL 91). If the record is in second file, but not in first file , then it should be written in to the output file.

Please let me know whether it can be done thru SuperC /File AID . The shop doesn't have comparex.

NB: I have tried SUPERC Line Compare option. It does not give the excepted results as it was Line Compare . Let me know if other option in SUPERC can be used to get the above requirement

murmohk1 · Posted: Mon Sep 03, 2007 1:17 pm

Balaji,

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

murmohk1,

The requirement with example

first file

8
6
4
2
second file
7
5
3
8

SuperC ( line compare option) compares first record(value 8) of first file with first record (value 7) of second file. Then second record (6) with second record(5). The last compare 2 with 8. 8 is written to final output file ( Using sort step to get only I's(Insert))

But requirement is first record(value 8) of first file should compare with all records so last record (value 8) and 8 should not be written to out put file .7,5,3 to be only written to outputfile as it is not found anywhere in first file.

Let me know whether it is possible thru SuperC

murmohk1 · Posted: Mon Sep 03, 2007 3:51 pm

Balaji,

Did you try all the SUPERC options? Following is the OP with your IP -

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

Murali,

The option used

PGM=ISRSUPC
PARM=('DELTAL','LINECMP',' ')

In sysin,
CMPCOLM 1:2,3:83

Need to compare 1:83 cols, just coded 1:2,3:83(test jcl)aware it same as 1:83
(no difference)

In file 1, 84th record has value 0679045678890765
In file 2, 28th record has value 0679045678890765

But the output has 679045678890765. But should not be.

Please let me know which option I'm going wrong

Thanks,
Balaji.

Anuj Dhawan · Posted: Mon Sep 03, 2007 7:21 pm

Hi,

Please post your JCL, input & expected output files, enclose them in 'Code' format while posting. Hopefully, you'll get better suggestions.

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

The code

/SUPERC EXEC PGM=ISRSUPC,
// PARM=('DELTAL','LINECMP',
// '')

//NEWDD DD DSN=FILE2,
// DISP=SHR

//OLDDD DD DSN=FILE1,
// DISP=SHR
//SYSIN DD *
CMPCOLM 1:2,3:83
/*
//OUTDD DD DISP=(NEW,CATLG),
// DSN=OUTPUTFILE,
// RECFM=FB,LRECL=91,
//* MGMTCLAS=SHRTBKUP,
// SPACE=(CYL,(500,50),RLSE),
// UNIT=DISK
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//*

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

I'm getting the below error message

"ISRS078I FALSE MATCHES CORRECTED. RESULTS MAY NOT REFLECT ALL MATCHES. SEE "ADDITIONAL NOTES" IN SUPERC TUTORIAL."

Please let me know how to proceed further.

Regards,
Balaji.

dick scherrer · Posted: Tue Sep 04, 2007 7:38 pm

Hello,

Is there some reason that the files are not both sorted in the same sequence?

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

Hello,

I'm comparing the previous version and current version of GDG. In test environment, I did copy the GDG versions to flat files.

I did SORT columns 1-83. After that I 'm not getting error message.

But the record with value 0679045678890765 is appearing both as Insert and delete

D - 0679045678890765

I - 0679045678890765

The D and I means its in both Input file(that is compared)

I have checked that value 0679045678890765 is present in both Input files . So it should not appear in the output file.

In file 1, 84th record has value 0679045678890765
In file 2, 28th record has value 0679045678890765

When I have only this record (0679045678890765)in the both input files
and delete all other records SuperC works fine i.e. 0 Insert 0 Delete

So this record 0679045678890765 along with other record does not yield the desired result

Please help.

Thanks,
Bala.

manihcl85 · New User Joined: 11 Jan 2007 Posts: 52 Location: chennai

Hi,

Try below JCL, which compare using COMPAREX utility

ashokm · Posted: Wed Sep 05, 2007 3:02 pm

Hi ,
You can easily achieve this in ICETOOL

Ashok M

itsbalaji · New User Joined: 12 Jun 2007 Posts: 7 Location: India

Hi Mani,

There is no CompareX here.

Thanks for your reply.

Regards,
Balaji.