Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to compare 2 files in fileaid?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
chtrisa

New User


Joined: 19 Dec 2006
Posts: 12
Location: chennai

PostPosted: Fri Apr 27, 2007 4:00 pm    Post subject: How to compare 2 files in fileaid?
Reply with quote

I have 2 flat files. i want to compare 2 files and list the different records.

for an ex:

input files
File1
aaa
bbb
ddd
hhh

File2
bbb
sss
ddd
zzz

the output must be
aaa
hhh

how to do this can any one suggest me
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Apr 29, 2007 7:56 am    Post subject:
Reply with quote

Hello,

To get the result you want, please search in the DFSORT forum.

Your question has been solved there. Hopefully, you are not restricted to using FileAid. . .
Back to top
View user's profile Send private message
student_mf

New User


Joined: 15 Jun 2007
Posts: 23
Location: pune

PostPosted: Tue Jun 19, 2007 12:50 pm    Post subject:
Reply with quote

Hi the scenario presented by chtrisa cant be done using file-aid?.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue Jun 19, 2007 4:42 pm    Post subject:
Reply with quote

chtrisa
you can do this using DFSORT.
Back to top
View user's profile Send private message
student_mf

New User


Joined: 15 Jun 2007
Posts: 23
Location: pune

PostPosted: Fri Jun 22, 2007 12:39 pm    Post subject:
Reply with quote

Hi krisprems is there any possibility that what chtrisa wanted can be done in file-aid with out using dfsort.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Jul 11, 2007 1:16 pm    Post subject:
Reply with quote

student_mf
I dont have much hands on File-Aid and so can't answer your question
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 11, 2007 8:04 pm    Post subject:
Reply with quote

Hello,

Are you just curious or is there a business reason for:
Quote:
is there any possibility that what chtrisa wanted can be done in file-aid with out using dfsort


Why would you not use the sort?
Back to top
View user's profile Send private message
lalitha_gld

New User


Joined: 12 Jul 2006
Posts: 24

PostPosted: Tue Jul 17, 2007 1:27 pm    Post subject: Re: How to compare 2 files in fileaid?
Reply with quote

I assume that you would know to do a basic compare using Fileaid option '10'.

To get the required output:
1. Mention file1 as OLD dataset & file2 as NEW dataset.
2. Under 'Compare - Criteria Options' set 'Modify print defaults' to 'y'.
3. Set 'Print DELETED records ===> Y '
4.Execute compare.

You will get the records from the file1 which are missed in file2.

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

New User


Joined: 15 Jun 2007
Posts: 23
Location: pune

PostPosted: Tue Jul 17, 2007 10:19 pm    Post subject: Re: How to compare 2 files in fileaid?
Reply with quote

thanks lalitha i got the required output
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
No new posts Finding difference between two PS fil... Vignesh Sid SYNCSORT 5 Mon Oct 30, 2017 1:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us