Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

I want mismatch recrord form one file alone

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
pranab_mohanty

New User


Joined: 28 May 2009
Posts: 1
Location: Chennai

PostPosted: Sat Aug 08, 2009 2:57 pm    Post subject: I want mismatch recrord form one file alone
Reply with quote

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
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Aug 10, 2009 10:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us