POLICY NUMBER |DATE1 |DATE2 |POLKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data ***********
TRA010005001 17.01.200716.01.2007dasd123
TRA010005002 20.02.200719.02.2008da12413
TRA010005003 21.02.200720.02.2008gfsdg43
TRA010005005 16.01.200715.01.2007sdfsdf5
TRA010005008 21.02.200720.02.2008sdfsdf4
**************************** Bottom of Data *********
file length is 55 with Pol num:25, DATE1: 10, DATE2:10, Polkey:10
second input file(cover file) is
Code:
POLICY NUMBER |DATE1 |DATE2 |COVKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data *************
TRA010005001 17.01.200716.01.2007dasd123
TRA010005002 20.02.200719.02.2008da12413
TRA010005004 15.01.200715.01.2007sdfsdf6
TRA010005006 21.02.200720.02.2008sdfsdf4
TRA010005008 21.02.200720.02.2008sdfsdf4
**************************** Bottom of Data *********
file length is 55 with Pol num:25, DATE1: 10, DATE2:10, Cltkey:10
third input file(client file) is
Code:
POLICY NUMBER |DATE1 |DATE2 |CLTKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data *************
TRA010005001 17.01.200716.01.2007dasd123
TRA010005003 21.02.200720.02.2008gfsdg43
TRA010005004 15.01.200715.01.2007sdfsdf6
TRA010005007 21.02.200720.02.2008sdfsdf4
TRA010005008 21.02.200720.02.2008sdfsdf4
**************************** Bottom of Data ***********
file length is 55 with Pol num:25, DATE1: 10, DATE2:10, Covkey:10
I want to have my first output file as following which has matching policy number, date1 and date2 in all three files.
OUTPUTFILE1:
Code:
POLICY NUMBER |DATE1 |DATE2 |POLKEY |COVKEY |CLTKEY
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+
***************************** Top of Data *********************************
TRA010005001 17.01.200716.01.2007dasd123 dasd123 dasd123
TRA010005008 21.02.200720.02.2008sdfsdf4 sdfsdf4 sdfsdf4
**************************** Bottom of Data *******************************
Second output file should contain records of Policy file which doesn?t have matching values of policy number, date1 and date2 either in Cover file or client file or both
OUTPUFILE2:
Code:
POLICY NUMBER |DATE1 |DATE2 |POLKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data ***********
TRA010005002 20.02.200719.02.2008da12413
TRA010005003 21.02.200720.02.2008gfsdg43
TRA010005005 16.01.200715.01.2007sdfsdf5
**************************** Bottom of Data *********
Third output file should contain records of Cover file which doesn?t have matching values of policy number, date1 and date2 either in Policy file or client file or both
OUTPUFILE3:
Code:
POLICY NUMBER |DATE1 |DATE2 |COVKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data *************
TRA010005002 20.02.200719.02.2008da12413
TRA010005004 15.01.200715.01.2007sdfsdf6
TRA010005006 21.02.200720.02.2008sdfsdf4
**************************** Bottom of Data *********
Fourth output file should contain records of Client file which doesn?t have matching values of policy number, date1 and date2 either in Policy file or Cover file or both
OUTPUFILE4:
Code:
POLICY NUMBER |DATE1 |DATE2 |CLTKEY
----+----1----+----2----+----3----+----4----+----5----+
***************************** Top of Data *************
TRA010005003 21.02.200720.02.2008gfsdg43
TRA010005004 15.01.200715.01.2007sdfsdf6
TRA010005007 21.02.200720.02.2008sdfsdf4
**************************** Bottom of Data ***********
I want to have the above submitted process done in Icetool using Splice, not easytrieve
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Madhu,
I believe this DFSORT/ICETOOL job will do what you asked for based on the example you showed. If there are other variations you didn't show, then the job may have to be tweaked a bit to cover those.
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: