I have two database one is db2 and the other is UDB that is teh mainframe
I have two views from both the sources and i have to join on one column.But the data type are different in both the datbase.(one it is numeric and the other it is varchar)
How should i go ahead .can i write the query to access the columsn from both the databse.there is no database link between the two databse.
Edited by anushka - 08 Jun 2008 at 4:41pm