Hi,
I had two files and i need to bringout the Unique records to the output file .
is it possible todo through a jcl or we need to write a cobol program, if yes can anyone pls let me how can we do throgh the JCL.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
For the example you show, you can use this DFSORT/ICETOOL job. But if there are other variations (e.g. records in file2 that are not in file1), the job might have to be modified depending on what you want for output. I assumed your input file has RECFM=FB and LRECL=80 and the "key" was in positions 1-7 - again, the job can be modified as appropriate.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
Hi,
The above solution is giving the Unique records by comapring both files, I need the Unique records in first input file only and don't want the unique records in 2nd input file, can anyone let me know how can we handle this, pls see the example
Hi,
I had a requirement, that I had two files and is having identical keys and size, i need to write the output, from the Unique records from 1st file only, can anybody let me know how can we do using icetool/dfsort.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed your input files have RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.