View previous topic :: View next topic
|
Author |
Message |
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
Hi ALL,
I have two flat file.
I have to compare both and if any new records are added then those should be copied to new flat file.
Only the new records.
Is their any way which we can do through file-aid or through jcl sort.
THANKS
SHRI |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Shri,
What I assumed here is, you want to EXTRACT records from File-2, which are not present in File-1... Pls confirm.
One more thing, Are the new records being added to the bottom always in the File-2.
Regards,
Priyesh. |
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
Hi priyesh,
Yes I want to extract the records from file-2 not present in file-1
the records are not added at the end. It is randomly added
thanks
Shri |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
ok then...
Check out for this DFSORT SMART Trick... which shows exactly what you are looking for.
Regards,
Priyesh. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Shri,
If you need more specific help, show an example of the records in your input files and what you expect for output. If there are duplicate records within either file, show that in your example. Also, give the RECFM and LRECL of each input file. |
|
Back to top |
|
|
|