View previous topic :: View next topic
|
Author |
Message |
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
bharath_gct2002 wrote: |
Thanks much Dick.. I have done the file joins using ICETOOL. But I am not sure of how to do a 2 file match in Assembler. And I doubt If I have to write a seperate program or to have that also in the same program.
If there is any sample Assembler program or code snippet which can explain me how to do a 2 file match that will be really helpful. |
Treat the 2-File Match/Merge sample code as psuedo-code.... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome Bharath
Try this from above (the embedded link)
Quote: |
Treat the 2-File Match/Merge sample code as psuedo-code.... |
and if there are any questions, post them here. That code will work in many languages. |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi !
Just two quick ideas.
1.) Whats about doing it the other way round. Read file-2, the big one, and check it against file-2, the small one. Then you read the big one only once.
2.) Whats about loading the data into DB2-Tables first. Then you could use normal Select/Fetch functions with key.
If no db2 installed, you could use VSAM KSDS. I think, this will save time.
By doing this load via another assembler programm, you have the chance to build your own key that would be best for your requirement.
Two or three little efficient programms run faster than one big one.
Also the manipulation of one file could be done quiet earlier than that of the end-of-day file.
Regards, UmeySan |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
FWIW - a simple 2-file match will perform faster than in-core searches, db2 tables, or vsam files.
Properly done, there should be no reason to read records from either of the "match" files more than once (after both files are placed in the same sequence). |
|
Back to top |
|
|
|