Announcement Announcement Module
No announcement yet.
How to combine queries for DB2 and oracle Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to combine queries for DB2 and oracle

    Title may be bit misleading, this is the actual scenario:
    >I am querying DB2 for list(parm1,parm2),resultset size-3 million
    >And next i am querying Oracle for list(parm1,parm4,parm5)result size:4 million

    So u can see that they have one parameter(parm1) in common, i need to loop through two results sets and see where the value of the parm1 equal in both the resultsets and do some logic with other parameters.Right now the way i am doing is running two for loops, which runs for like 12X10^12 times, which takes a lot of time.Can any one gimme some optimized(like querying two databases at atime) way to do this plzz.