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
 

 

Need to compare two files with one Column

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

New User


Joined: 19 Dec 2004
Posts: 24
Location: hyderabad

PostPosted: Wed Dec 03, 2008 1:26 pm    Post subject: Need to compare two files with one Column
Reply with quote

Hi,

Let me know how to do this comparision.

I need to compare two files with one Column, which is present in different positions and copy all the matched records to new output file.


Thanks,
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Wed Dec 03, 2008 3:02 pm    Post subject: Reply to: Need to compare two files with one Column
Reply with quote

Hi,

Quote:
need to compare two files with one Column, which is present in different positions and copy all the matched records to new output file.


Reformat and compare your files using SPLICE/SELECT option of DFSORT.

Tell us your key field positions. Also the sample input and output files.

Also search this forum.
Back to top
View user's profile Send private message
venkatarao

New User


Joined: 19 Dec 2004
Posts: 24
Location: hyderabad

PostPosted: Wed Dec 03, 2008 6:37 pm    Post subject: Reply to: Need to compare two files with one Column
Reply with quote

Hi Aaru,

Both are FB Files.
File1 record length 20 bytes we need to take firest 10 bytes of account number field.

File2 record length is 200 bytes we need compare 10 bytes of starting from 21 postion.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Dec 03, 2008 11:09 pm    Post subject:
Reply with quote

venkatarao,

Show an example of the records in each input file (relevant fields only) and what you expect for output. Give the "rules" for getting from input to output. If input file1 can have duplicates within it, show that in the example. If input file2 can have duplicates within it, show that in the example. Give the starting position, length and format of all relevant fields.
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 member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


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