Dear All,
I'm new in DB2 a lot of question rise went
We want to migrate our database from SQL Server to DB2
I want to know is it possible in DB2 to query field from two or more database in one server,
example
I have two database
1. database a
consist of table users ( userid,companyi d,companyname)
2. Database B
consist of table user_log
(userid,usernam e,logid,date)
my question is
I want to query userid,username from user_log inner join [database a].users where userid in(select userid from [database a].users)
thank's before
Regards
Agus Wahyu
I'm new in DB2 a lot of question rise went
We want to migrate our database from SQL Server to DB2
I want to know is it possible in DB2 to query field from two or more database in one server,
example
I have two database
1. database a
consist of table users ( userid,companyi d,companyname)
2. Database B
consist of table user_log
(userid,usernam e,logid,date)
my question is
I want to query userid,username from user_log inner join [database a].users where userid in(select userid from [database a].users)
thank's before
Regards
Agus Wahyu