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
 

 

comparing two files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: comparing two files
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    Post subject: Reply to: comparing two gdg files
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    Post subject: Reply to: comparing two gdg files
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

Site Director


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

PostPosted: Tue Jul 01, 2008 2:51 am    Post subject:
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

Senior Member


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

PostPosted: Tue Jul 01, 2008 4:45 am    Post subject: Reply to: comparing two gdg files
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: 2171
Location: @my desk

PostPosted: Tue Jul 01, 2008 8:14 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Tue Jul 08, 2008 1:09 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Tue Jul 08, 2008 1:16 am    Post subject: Reply to: comparing two files
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    Post subject:
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

Site Director


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

PostPosted: Tue Jul 08, 2008 1:28 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Tue Jul 08, 2008 2:12 am    Post subject:
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    Post subject:
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

Senior Member


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

PostPosted: Wed Jul 09, 2008 3:24 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts Adding records from two files into on... shiitiizz SYNCSORT 4 Mon Sep 19, 2016 8:41 pm


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