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

Comparing 2 VBA files of 8188 length


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gsbrar16

New User


Joined: 21 Dec 2006
Posts: 27
Location: india

PostPosted: Mon May 28, 2007 5:16 pm
Reply with quote

Hi All,

I am trying to compare 2 VBA files of record length 8192(total).

When i am using Fileaid or SuperCE for this. i am not getting the correct results. Can this be done using DFSORT?

Also can we find duplicates from 2 FB files of length 8188 using DFsort.

Thanks and Regards
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon May 28, 2007 5:41 pm
Reply with quote

gsbrar16

are you comparing the whole record length or want to compare the particular key field?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon May 28, 2007 9:45 pm
Reply with quote

gsbrar16,

For each of the two cases, you need to show an example of the records in each input file and what you expect for output, and explain the "rules" for getting from input to output.
Back to top
View user's profile Send private message
gsbrar16

New User


Joined: 21 Dec 2006
Posts: 27
Location: india

PostPosted: Tue May 29, 2007 8:07 am
Reply with quote

Hi,

I want to compare the entire 8188 length.

file A is like
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd

file B is slike

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbb
cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee


I want a final files which should show the unmatching records of the 2 files with a letter 1 or 2 in the start which can tell us that this rec belongs to which file.
1bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
1dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
2bbbbbbbbbbbbbbbbbbbb
2eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

Thanks
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue May 29, 2007 12:57 pm
Reply with quote

use "Create files with matching and non-matching records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

here if you merge F1ONLY and F2ONLY, you will get the solution for your request.
Back to top
View user's profile Send private message
gsbrar16

New User


Joined: 21 Dec 2006
Posts: 27
Location: india

PostPosted: Tue May 29, 2007 5:39 pm
Reply with quote

Hi,
Thanks for the reply. This will serve my purpose.

Please also tell that where can i find the information regarding SPLICE and BUILD (i am not able to understand it properly from icetool basics manual).


Thanks
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue May 29, 2007 6:07 pm
Reply with quote

you can find icetool mini user guide in

www.ibm.com/servers/storage/support/software/sort/mvs/icetool/

Find the information for build in

publibz.boulder.ibm.com/zoslib/pdf/ice1cg20.pdf

find all DFSORT/ICETOOL Reference Material here

Use [URL] BBCode for External Links

For SPLICE, it is better to check for the examples in this forum.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue May 29, 2007 8:45 pm
Reply with quote

Quote:
Thanks for the reply. This will serve my purpose.


No, it won't.

Quote:
I want to compare the entire 8188 length.


SPLICE cannot "compare" that many bytes. The maximum you can "compare" is 4088 bytes.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
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 VB to VB copy - Full length reached SYNCSORT 8
Search our Forums:

Back to Top