I think that the JOINKEYS may be able to do what you want. But I've not used it myself.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/5.0 John McKown Systems Engineer IV IT Administrative Services Group HealthMarketsR 9151 Boulevard 26 ? N. Richland Hills ? TX 76010 (817) 255-3225 phone ? [email protected] ? www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarketsR is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. ?The Chesapeake Life Insurance CompanyR, Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of Minoru Massaki > Sent: Monday, January 23, 2012 10:47 AM > To: [email protected] > Subject: DFSORT - How to split detailed record based on master record > > I'm looking for a way to do following by DFSORT. I have read through > DFSORT manuals but I could not find out the method. Your help would > be highly appreciated. > > There is a master file which contains Volume serial (VOLSER). The > master file is sorted by VOLSER and there is NO duplicate VOLSER. > Each record of the detailed record file contains VOLSER and data set > name. The detailed record file is also sorted by VOLSER and there are > duplicate VOLSER. In some case, detailed record file does not contain > VOLSER record which is in mster record. > I want to split detailed record file into two files based on master > record file as following: > > Master record file > VOL000 > VOL001 > VOL005 > VOL010 > > Detailed record file > VOL001 AAA > VOL002 BBB > VOL005 CCC > VOL005 DDD > VOL007 EEE > VOL007 FFF > > DFSORT output > master-exist > VOL001 AAA > VOL005 CCC > VOL005 DDD > > non-master > VOL002 BBB > VOL007 EEE > VOL007 FFF > > > Can DFSORT do it? > > > -- > > 全先 実 - Minoru Massaki (M*M) > E-mail: [email protected] > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
