Join table from two diff. DB server?

Hi all, I am wondering if I can join table from two diff. server but the remote server allows only read access. How can I join the table in the remote site? Is there anyway to join those tables? For examples; If I have table in the local DB server name personal_data and I have table in the remote DB server name credit_card_info table and both are link using the SSN number. How can I join those two tables on the remote site if I have only read access permission? Please advice me! I am using Informix Server 9.x on both DB Server and UNIX Solaris is my OS. Thank you ver much. Wira Soedarmono

Wira Soedarmono <wsoedarm@Vorlon.odc.net> wrote in message news:7k96gu$np7$1@holocron.odc.net... > Hi all, I am wondering if I can join table from two diff. server but the remote server allows > only read access. How can I join the table in the remote site? Is there anyway to join those tables? > For examples; > > If I have table in the local DB server name personal_data and I have table in the remote DB > server name credit_card_info table and both are link using the SSN number. How can I join those > two tables on the remote site if I have only read access permission? > Please advice me! > While on my local_database at my local_instance: select col1, col2, col3 from myloctable mlt, rmtdb@personal_data:myrmttable mrt where mlt.ssn_number = mrt.ssn_number; As long as you have select permission against the remote table, and the instances are configured to see each other, this should work. Keaton

Wira, You could use OpenLink's Virtuoso to connect to multiple databases. Please visit http://www.openlinksw.com to download a beta version. (Note: Virtuoso is just about ready to be commercially released.) General Information: Virtuoso is a revolutionary, next generation, high-performance virtual database engine for the Distributed Computing Age. It is a core universal data access technology set to accelerate our advances into the emerging Information Age. Virtuoso provides transparent access to your existing data sources, which are typically databases from different database vendors. Through a single connection, Virtuoso will simultaneously connect your ODBC, JDBC, UDBC, OLE-DB client applications and services to data within Oracle, Microsoft SQL Server, DB/2, Informix, Progress, CA-Ingres and other ODBC compliant database engines. All your databases are treated as single logical unit. The full installation takes up less than 10MB of disk space. The actual database element takes up less than 5MB. Virtuoso currently supports Linux ("glibc2" and "libc5" based distributions), Windows 95/98/NT/2000, and UNIX (all flavors). There are plans to port Virtuoso to the OS390, OS400, VMS, and MacOS platforms subject to demand. -- Thanks, Edward A. Geddis Technical Support Consultant OpenLink Software http://www.openlinksw.com Making Technology Work for You Wira Soedarmono <wsoedarm@Vorlon.odc.net> wrote in message news:7k96gu$np7$1@holocron.odc.net... > Hi all, I am wondering if I can join table from two diff. server but the remote server allows > only read access. How can I join the table in the remote site? Is there anyway to join those tables? > For examples; > > If I have table in the local DB server name personal_data and I have table in the remote DB > server name credit_card_info table and both are link using the SSN number. How can I join those > two tables on the remote site if I have only read access permission? > Please advice me! > > I am using Informix Server 9.x on both DB Server and UNIX Solaris is my OS. > > Thank you ver much. > > > Wira Soedarmono >