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
 

 

Compare 2 VB files with large volume of data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
manjushal

New User


Joined: 17 May 2007
Posts: 2
Location: India

PostPosted: Wed May 23, 2007 4:16 pm    Post subject: Compare 2 VB files with large volume of data
Reply with quote

hi,

I want to compare 2 VB files (max rec length 4504) which have large volume of data. SUPERCE is not able to display the complete record with differences and I don't want to use File-aid.
Can anyone suggest me a way to do this. I basically want to easily identify the differences between existing records/newly inserted records/deleted records. The position where the difference is should be highlighted

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Wed May 23, 2007 4:35 pm    Post subject: Re: Compare 2 VB files with large volume of data
Reply with quote

Quote:
I don't want to use File-aid


Just wondering....

Do You have File-Aid available ?
Can File-Aid do what You ask ?
if both answers are yes why the quoted assertion ??

regards
Back to top
View user's profile Send private message
manjushal

New User


Joined: 17 May 2007
Posts: 2
Location: India

PostPosted: Wed May 23, 2007 5:46 pm    Post subject: Re: Compare 2 VB files with large volume of data
Reply with quote

File-Aid is getting obsolete in our system, so I cannot use File-Aid and hence need to look for some other option.
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Wed May 23, 2007 5:48 pm    Post subject:
Reply with quote

Quote:
SUPERCE is not able to display the complete record with differences

May I know why? It may be the case that you are only trying it in 'Online',
have you tried superce in 'batch'?
I don't know if there will be any problem in using a file of recln= 4504.
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Wed May 23, 2007 5:49 pm    Post subject:
Reply with quote

Quote:
File-Aid is getting obsolete in our system,

Ok, they are making it obsolete, then what is the newer thing?
[/quote]
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Wed May 23, 2007 10:58 pm    Post subject:
Reply with quote

EComp can easily process that.
Email me if you want more information.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Thu May 24, 2007 11:27 am    Post subject: Re: Compare 2 VB files with large volume of data
Reply with quote

Try with "Long" option in the Listing Type instead of "delta" and do the comparison in Batch.And you can use CMPCOLM 5:60 75:90 to identify the position where the differences are happening...

Regards,
Syam
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 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 Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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