Heterogeneous queries 1

[dvfilho]

Hi,

I'm trying to retrieve data from two different database servers using BDE ( see example below ).

Select A.VENDORNO, B.VENDORNO
From "BDEMOS:VENDORS" A, ":IBLOCAL:VENDORS" B
where A.VENDORNO = B.VENDORNO

The query above works fine unless the columns named VENDORNO are of different datatypes in tables A and B ( suppose integer in table A and varchar in table B ).

The problem is that you cannot use any specific function of the database servers (like TO_CHAR in Oracle) to match the types in two tables. Then, the error returned in this case is "type mismatch".

Any ideas to solve this problem ?

Thanks.

 

[McMerfy]

Try this (not sure if it'd work though):

Select A.VENDORNO, B.VENDORNO
From ":DBDEMOS:VENDORS" A, ":IBLOCAL:VENDORS" B
WHERE (CAST(A.VENDORNO AS VARCHAR) = B.VENDORNO)

HTH

--- markus