remote server question

I have the following scenario Server1 Server2 Database Server 'Test' exists on both machines in both also contain database 'mydb' If I am connected to db server Test and db mydb on Server 1 , I can access a table with the following statement select * from mydb@Test:atable Is it possible to add Server2 to the statement so that I may select from it while I am connected to Server1. My guess is I would have a passwd problem, but was curious if anyone knew if this could be done. TIA

>ubject: remote server question >From: "Michael Talbot" michael.talbot@telops.gte.com >Date: 09.03.00 23:17 W. Europe Standard Time >Message-id: <8a97tt$1gc$1@news.gte.com> > > I have the following scenario > >Server1 >Server2 > >Database Server 'Test' exists on both machines in both also contain database >'mydb' > >If I am connected to db server Test and db mydb on Server 1 , I can access a >table with the following statement > >select * from mydb@Test:atable> >Is it possible to add Server2 to the statement so that I may select from it >while I am connected to Server1. > >My guess is I would have a passwd problem, but was curious if anyone knew if >this could be done. > >TIA > Yes it can be done. On older versions, just keep the length of the table name, including the qualifiers databasename@servername:"owner".tablename under 18 char. Nona