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 2 VBA files of 8188 length

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Comparing 2 VBA files of 8188 length
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    Post subject:
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 Moderator


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

PostPosted: Mon May 28, 2007 9:45 pm    Post subject:
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    Post subject:
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    Post subject:
Reply with quote

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

http://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    Post subject:
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    Post subject: reference manuals
Reply with quote

you can find icetool mini user guide in

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

Find the information for build in

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

find all DFSORT/ICETOOL Reference Material here

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html

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 Moderator


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

PostPosted: Tue May 29, 2007 8:45 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL 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 15 Thu Dec 01, 2016 8:28 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 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 Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am


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