IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

comparing two files


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 01, 2008 1:39 am
Reply with quote

I have 2 gdg files....and I want to compare these two as follows

file1(3) file2(4)

field1 ravi field1 mahesh
field2 233 field2 444
field3 USA field3 canada

after comparing,,,i want to see the results as mentioned above.

can you please guide me how I can do this?

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

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 01, 2008 2:15 am
Reply with quote

please let me know if you need anyother infn
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 01, 2008 2:18 am
Reply with quote

file1(gdgv3) file2(gdgv4)

field1 ravi | field1 ravi
field2 233 | field2 233
field3 USA | field3 USA
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jul 01, 2008 2:51 am
Reply with quote

Hello,

Please start over and make a more complete presentation.

Your first and third posts appear to be related, but exactly how is unclear.

You need to post some input from both files and the output you want from that posted input. You also need to explain any "rules" you want followed.
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley

PostPosted: Tue Jul 01, 2008 4:45 am
Reply with quote

Quote:
I want to compare these two (files)

Use SUPERC to compare files.

Quote:
i want to see the results

Aside from IEBIBALL, there is no 'see' utility in JCL. You have to see it after the job ends, so just browse the file produced by SUPERC.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Jul 01, 2008 8:14 am
Reply with quote

Hello pmn2cdac,

You can make use of the "Code" option to post sample input and output records to give a better understanding of your requirement.

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

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Mon Jul 07, 2008 11:37 pm
Reply with quote

When I compare these two files, output should display compare result as follows.

Code:

file1(gdgv3) file2(gdgv4)

field1 ravi | field1 ravi
field2 233 | field2 233
field3 USA | field3 USA
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jul 08, 2008 1:09 am
Reply with quote

Hello,

You have repeated your post, but you have not added any info to help us help you. Using "Code" can make a post more readable, but does not add any useful information automatically. You must provide the info.

I suggest you run a compare with SuperC and post back here what you get and what you want to be different from what you get. You can use very small files for demonstration (like the 3-field examples here) rather than files with a large number of fields.
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 08, 2008 1:16 am
Reply with quote

I compared with SuperC but the result I got is not in my format.

the result should be in formated mode of both fields and values as per below.
Code:

GDG1              GDG2

field1 ravi|      field1 ravi
field2 233 |      field2 233
field3 USA |      field3 USA


Please let me know if you need anyother information.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jul 08, 2008 1:16 am
Reply with quote

Hello again,

The duplicate topic of the same question has been deleted. . .

d
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 08, 2008 1:18 am
Reply with quote

Sorry about that.

Please guide me how i can do it.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jul 08, 2008 1:28 am
Reply with quote

Hello,

Quote:
Sorry about that.
Not a problem icon_smile.gif

Does your system have FileAid? If not (or if you're not sure), i'd ask the system support people what tool(s) are available on your system to do what you want.

If there is no tool already installed, you may need to use SuperC and adjust your expectations for the output.

You could always write your own compare code for your specific file if the output simply must be in your posted format.
Back to top
View user's profile Send private message
pmn2cdac

New User


Joined: 23 Dec 2007
Posts: 27
Location: Bangalore

PostPosted: Tue Jul 08, 2008 2:06 am
Reply with quote

I do't have fileaid tool in my system...

How do you adjust superc as per my expectection?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jul 08, 2008 2:12 am
Reply with quote

Hello,

Quote:
How do you adjust superc as per my expectection?
You don't - you have to adjust your expectations. . . icon_sad.gif

You use SuperC as delivered and possibly manipulate the SuperC output. I suspect that if you want the data only field by field, you will need to find some product already installed, buy one (not likely), or build a specific piece of code for your task.

Have you talked with your system support people or other application developers? Many, many organizations have some kind of tool available.
Back to top
View user's profile Send private message
sid_aec

New User


Joined: 01 Jul 2008
Posts: 60
Location: Kolkata

PostPosted: Wed Jul 09, 2008 2:14 pm
Reply with quote

If you dont have fileaid then I hope some other product like INSYNC or some thing like that may be there to work with various file systems.
There you will find any option like FILED COMPARE.Through that you can get your result.Check by which you edit files with copybooks.That tool will help you out. Dick please correct if I am wrong anywhere.

Thanks.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Jul 09, 2008 3:24 pm
Reply with quote

Hi,

SuperC is rather easily available at sites.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 2
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top