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

Can i use sort to match two files?


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

New User


Joined: 01 Aug 2005
Posts: 14

PostPosted: Mon Jul 23, 2007 2:54 pm
Reply with quote

Hi,All,

I found many examples to use icetool to match two files in this forum.But i could only use sort.Can i use sort to do this?

eg.

infile1:

01aaa
02bbb
03ccc

infile2:
01AA
03DD

outfile:
01aaaAA
02bbb
03cccDD
(the first 2 bytes of the two infiles are keys for matching)

Thanks for your reply.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Jul 23, 2007 3:11 pm
Reply with quote

Have you looked at any previously posted topics such as Matching files using DFSORT?
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 Jul 23, 2007 8:15 pm
Reply with quote

Quote:
But i could only use sort.


Why? If you have DFSORT, then you have DFSORT's ICETOOL. ICETOOL has been shipped with DFSORT since 1991.
Back to top
View user's profile Send private message
jay86

New User


Joined: 01 Aug 2005
Posts: 14

PostPosted: Tue Jul 24, 2007 7:11 am
Reply with quote

Thanks.

There is no job using icetool in our production batch enviroment.So i'm afraid to use it if there is any issues about version,authority or other problems.

and another reason is i have never used icetool before and i am not familiar with this utility.
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 Jul 24, 2007 10:22 pm
Reply with quote

Quote:
So i'm afraid to use it if there is any issues about version,authority or other problems.


I have no idea what you mean by "issues". ICETOOL is an official part of DFSORT - it has been since 1991. If you're using DFSORT, there should not be any version or authority issues or other problems with using DFSORT's ICETOOL. You're fears are unfounded.

Quote:
and another reason is i have never used icetool before and i am not familiar with this utility.


There are many, many, many examples using DFSORT's ICETOOL on this board. Just do a search. Complete documentation on DFSORT's ICETOOL is available online at:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.0?DT=20060615185603

and

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/3.0?DT=20060615173822

If you want me to show you how to do what you want with DFSORT's ICETOOL, give me the RECFM and LRECL of the input files.
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 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 JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top