View previous topic :: View next topic |
Author |
Message |
jasonarul Beginner
Joined: 22 Jul 2008 Posts: 2 Topics: 1 Location: Chennai
|
Posted: Thu Jul 31, 2008 8:52 am Post subject: Using Joinkeys |
|
|
Hi,
I have a prob using join keys, there were related posts but nothing was matching my criteria, so please help me out with a solution.
First 14 digits is sequence number
00 and 01 in bold are record types,
//SORTJNF1 DD *
00000000000020000000000000000000000000P
0000000000002001KADHC02000 00000P 20080730
00000000000021000000000000000000000000P
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730
00000000000022000000000000000000000000P
0000000000002201KADHC01000 00000P 20080730
//SORTJNF2 DD *
00000000000021010000024000
00000000000076010000019000
I need 2 output files,
Whenever there is a match in sequence number between input file 1 and 2, it should come in Output file2.
Under no match, it should come in Output file 1.
Output File 1:
00000000000020000000000000000000000000P
0000000000002001KADHC02000 00000P 20080730
00000000000022000000000000000000000000P
0000000000002201KADHC01000 00000P 20080730
Output File 2:
00000000000021000000000000000000000000P
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730
0000000000002101KADHC01000 00000P 20080730 |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
|
Back to top |
|
|
jasonarul Beginner
Joined: 22 Jul 2008 Posts: 2 Topics: 1 Location: Chennai
|
Posted: Fri Aug 01, 2008 1:21 am Post subject: |
|
|
Hi vkphani,
Thanks for providing me th link.
Got the desired results |
|
Back to top |
|
|
|
|