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: 10274
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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am


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