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
 
Can i use sort to match two files?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Can i use sort to match two files?
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: 3158
Location: Tucson AZ

PostPosted: Mon Jul 23, 2007 3:11 pm    Post subject:
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 Moderator


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

PostPosted: Mon Jul 23, 2007 8:15 pm    Post subject:
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    Post subject:
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 Moderator


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

PostPosted: Tue Jul 24, 2007 10:22 pm    Post subject:
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:

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

and

http://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    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 Changing sort Card Dynamically vickey_dw DFSORT/ICETOOL 4 Sat Aug 19, 2017 2:33 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am


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