Hi all,

We are trying to merge data from 2 different databases, does anybody have any ideas how this can be acheived

Thanks

if you mean, select data from 2 db in the same query ..?
this is only possible if a nickname has been defined over the second table
in that case the table is seen as local and can be used in a regular join..
nicknames support between db2 db is included in base code

Using the federated database feature.
For detail pls refer to the information center for DB2