View previous topic :: View next topic
|
Author |
Message |
pranab_mohanty
New User
Joined: 28 May 2009 Posts: 1 Location: Chennai
|
|
|
|
Hi All,
I will appriciate if anybody would help me.
I have two files as below
FILE-1
Code: |
---------------------KEY1--- KEY2
365C 3E GD89 180000 180000M001 SR1U11HX
365C MF GD90 180000 180000M101 SR1U11HX
365C 3E GD93 180000 180000M401 SR1U11HX
365C MF GD94 180000 180000M501 SR1U11HX
365C 3E GD89 180001 180001M001 SR2U11HX
365C MF GD90 180001 180001M101 SR2U11HX
201C 4G GA15 185105 185105M001 SR2I11HX
201C 4H GA16 185105 185105M101 SR2I11HX
365C 3E GD89 180002 180002M001 SR4U11HX
365C MF GD90 180002 180002M101 SR4U11HX
|
File-2
Code: |
ccyy| KEY1--------LEY2 |
2009180075 180075D210NEW YORK !SPAP NEW
2009180079 180079D201SPAP UNICARE NESPAP
2009200040 200040R001CITY OF SUFFOLKCITY
2009200045 200045M001LANDAMERICA FINLAND
2009200045 200045M002LANDAMERICA FINLAND
2009C21376 1805RS LSI CORPORATIONLSI
2009200049 200049M001INTERNATIONAL UINTE
|
The combination of key1 and key2 is the search criteria.
Key-1 = 6bytes and Key-2 = 10 bytes
I want mismatch record from File-1 alone. Noted point is the Position of Key-1 and Key2 in both files are different.
Please help. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
pranab_mohanty,
1. What is the LRECL and RECFM of FILE 1?
2. What is the LRECL and RECFM of FILE 2?
3. What is the position of the key in FILE 1? . Is the key character format or a packed decimal?
4. What is the position of the key in FILE 2? . Is the key character format or a packed decimal?
5. Do you have duplicates in any of the files based on the key combo?
6. Show me a sample of desired output also.
Thanks |
|
Back to top |
|
|
|