Jim Fenner wrote: >I was asked today the following: > >Recently I have been given to understand that DFSORT is capable of >processing 2 flat files to mimic >1. DB2 inner join on a given key and drop non-matching records. >2. DB2 not exists - drop records in file 1 if the key matches to a >record in file 2 > >My very quick reading of the DFSORT manual this morning suggests that >this is not the case. > >From your experience, cold anyone please advise whether you believe that >DFSORT is capable of this functionality. >If you have example control statements, then that would also be much >appreciated.
You can use the SPLICE operator of DFSORT's ICETOOL to do some types of matching. I don't use DB2, so I don't know from your DB2 descriptions if SPLICE can be used for 1 and/or 2. If you show me an example of the input records in each file and what you want the output records to look like and tell me the RECFM and LRECL of each input file, I can tell you tomorrow if SPLICE can do it and show you the jobs. But before doing that, you might want to take a look at the following examples to see if they answer your questions: Smart DFSORT Trick for matching: http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05 SPLICE examples: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/6.13.2?DT=20050222160456 Frank Yaeger - DFSORT Team (IBM) Specialties: ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
