I have completed this requirement with Syncsort. Option Equals and "When=Group"..
Thanks for all of ur help -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Donald Johnson Sent: Tuesday, July 06, 2010 8:30 PM To: [email protected] Subject: Re: Query in Sort The Two file match in EZT assumes the files are sorted in desired sequence already, and will present them to the program in either both files, or one or the other if they exist only there. For example: If File1 has the following records AAA BBB FFF GGG JJJ and File2 has the following records DDD EEE FFF HHH JJJJ Then you will get the records presented to you in this order File1 only AAA File1 only BBB File2 only DDD File2 only EEE File1 match File2 FFF File1 only GGG File2 only HHH File1 match File2 JJJ So you will need to determine when you have a match, how to set a switch to keep reading File1 for the children recs. The other option if you have the IMS option for EZT is to do a GU on the File2 key value and then GNP the rest of the children. * Don * On Sat, Jul 3, 2010 at 7:02 PM, Ram Study <[email protected]> wrote: > But this will again be a Linear search right..? > > Say I have 400000 records in file A and 9000000 in File B. > I have to process 400000 * 9000000 times:( > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf > Of Donald Johnson > Sent: Friday, July 02, 2010 6:58 PM > To: [email protected] > Subject: Re: Query in Sort > > In EZT, you could do a two-file match and use logic like this: > > If Matched unload selection > Turn on need-children switch > Write output record from unload > Else > if unload and need-children > write output record from unload > Else > turn off need-children switch > end-if > end-if > > This is "out of head" coding, so will need some tweaking... If you need > more > specifics, let me know and I can dig up one of my two-file match programs > from a while ago. > > * Don * > > On Thu, Jul 1, 2010 at 10:19 PM, RAMBALAJI S > <[email protected]>wrote: > > > Hi All, > > > > > > > > > > My input files are as follows > > > > > > > > File1 --> IMS DB unload - Sequential file having Parent and child > > combination > > > > > > > > SEGMENT1 RAM12345 --> Numeric after name is the key--> 12345 Position > - > > 12 Length --> 5 > > > > SEGMENT2 .. > > > > SEGMENT3.. > > > > SEGMENT4.. > > > > SEGMENT5.. > > > > SEGMENT6. . > > > > > > SEGMENT1 BAL23456 > > > > SEGMENT2 .. > > > > SEGMENT3.. > > > > SEGMENT4.. > > > > SEGMENT5.. > > > > SEGMENT6. . > > : > > > > : > > > > > > SEGMENT1 MAM34567 > > > > SEGMENT2 .. > > > > SEGMENT3.. > > > > SEGMENT4.. > > > > SEGMENT5.. > > > > SEGMENT6. . > > > > > > > > File2 - Normal segential file --> position to be compared --> 1 length > -->5 > > > > 12345 > > > > 45678 > > > > > > > > > > Output required > > > > > > > > > > SEGMENT1 RAM12345 > > > > SEGMENT2 .. > > > > SEGMENT3.. > > > > SEGMENT4.. > > > > SEGMENT5.. > > > > SEGMENT6. . > > > > > > > > My Requirement is, I have to match the two files with the position > > mentioned below > > > > Say File1 --> 12th position of length 5 --> this is present in SEGMENT1 > > alone > > > > File2 --> 1st position of length 5 > > > > > > > > IF Compared Key in Segment1 of file1 matches with the file2 below child > > segments also needs to be written in out file. Segments are repetetive > (Say > > we can have 5 Segment2 or 1 or it maynot have the segment2 also) and > > segment1 is not in sorted order. If I sort the child segments gets messed > > up. Iam not able to perform linear sort since record size is huge. > > > > > > > > Hope Iam clear. Any one has a suggestion on finding a suitable logic. > > > > Iam fine with COBOL/SYNCSORT/EASYTRIEVE > > > > Regards, > > Ram Balaji. > > > > _________________________________________________________________ > > Bollywood, beauties and the latest flicks on MSN entertainment > > http://entertainment.in.msn.com/ > > ---------------------------------------------------------------------- > > 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 > > > > ---------------------------------------------------------------------- > 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 > > > __________ Information from ESET Smart Security, version of virus signature > database 5246 (20100702) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > __________ Information from ESET Smart Security, version of virus signature > database 5246 (20100702) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > ---------------------------------------------------------------------- > 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 > ---------------------------------------------------------------------- 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 __________ Information from ESET Smart Security, version of virus signature database 5255 (20100706) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5255 (20100706) __________ The message was checked by ESET Smart Security. http://www.eset.com ---------------------------------------------------------------------- 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
