Great! I'm glad you could get it with SyncSort - I learned something today! * Don *
On Wed, Jul 7, 2010 at 12:33 PM, Ram Study <[email protected]>wrote: > 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 > ---------------------------------------------------------------------- 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
