1. i want to compare two file which have identical column and one file contains more rows compare to others i want rectify extra number of rows which are present in previous file.
and i want to write these extra rows in third file using JCL only
i want to compare two file ..
1. Number of column in both file are same or may be different,,,
sequence is also not identical
for example:
File 1: colum1 colum2 colum3 colum4 colum5 colum6
Name school marks adress DOB hobies
File 2: colum1 colum2 colum3 colum4 colum5 colum6
DOB adress marks Name hobies school
file1 contains more number of rows comapre to file2
i want to compare File1 & File2 and write in File3 extra number of rows
File3::
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
satish1978,
You haven't given enough information to make it clear what you want to do.
Please show an example of the records/rows (relevant fields) in each input file and what you expect for output, and explain the rules for getting from input to output. If input file1 can have duplicates, show that in your example. If input file2 can have duplicates, show that in your example.
Give the starting position, length and format of each relevant field.
Two files record length are same with no header information. And LRECL = 133
File 1:
Cust No Chk number Chk Amount Due date INV NO
Reliance 12345678 4,0000 10/06/07 456789
Ariel 456789 6,000 20/06/07 678900
Hutch 678909 7,0000 23/06/07 780000
VODA 978658 8,0000 25/06/07 999999
File2:
Cust no Amount Due date Inv NO Chk No
Reliance 4,0000 10/06/07 456789 12345678
Ariel 6,000 20/06/07 678900 456789
Hutch 7,0000 23/06/07 780000 678909
VODA 8,0000 25/06/07 999999 978658
Reliance 50,0000 10/06/07 7689000 56789000
Ariel 60,000 20/06/07 9999999 78965432
Hutch 70,000 23/06/07 888888 2398679
Major key is check number and invoice number use this key in two files
And compare extra column and write in output report using ICETOOL
Output File ::::
Cust No Chk No Inv No Due date Amount
Reliance 56789000 7689000 10/06/07 50,0000
Ariel 78965432 9999999 20/06/07 60,000
Hutch 2398679 888888 23/06/07 70,000