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 High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 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 Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


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