Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Using multiple databases in DB2 query

Posted on 2003-03-09
Medium Priority
Last Modified: 2012-05-04
 I have 2 databases named DB1 and DB2 running in same instance of DB2 server installation in AIX. I would like to join table1 of DB1 and table2 of DB2 in same query. so query will looks like,

select DB1.table1.fieldname1,DB2.table2.fieldname2 from DB1.tablename1, DB2.tablename2


Question by:mohan_555
1 Comment
LVL 13

Accepted Solution

ghp7000 earned 750 total points
ID: 8111071
This question already answered, see Data Transfer Error on 02/14/2003

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question