Are selects accross DB instances possible?

Hi, Is it possible to perform a select with a sub-select to a different DB instance? Eg.: select count(*) from testdb@TESTDB_1_NET:table_on_db1 tdb1 where not tdb1.x in ( select tdb2.x from testdb@TESTDB_2_NET:table_on_db2 tdb2); Where onconfig contains both TESTDB_1_NET and TESTDB_2_NET using onsoctcp connections to two different DB instances with an identical DB replicated between them. Is this possible? Cheers, Tim

Tim said: > > Is it possible to perform a select with a sub-select to a different DB > instance? Eg.: > > select count(*) > from testdb@TESTDB_1_NET:table_on_db1 tdb1 > where not tdb1.x in ( > select tdb2.x > from testdb@TESTDB_2_NET:table_on_db2 tdb2);> > Where onconfig contains both TESTDB_1_NET and TESTDB_2_NET using > onsoctcp connections to two different DB instances with an identical DB > replicated between them. > > Is this possible? Why are you asking? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com

Tim wrote: > > Hi, > > Is it possible to perform a select with a sub-select to a different DB > instance? Eg.: > > select count(*) > from testdb@TESTDB_1_NET:table_on_db1 tdb1 > where not tdb1.x in ( > select tdb2.x > from testdb@TESTDB_2_NET:table_on_db2 tdb2);> > Where onconfig contains both TESTDB_1_NET and TESTDB_2_NET using > onsoctcp connections to two different DB instances with an identical DB > replicated between them. > > Is this possible? > > Cheers, > > Tim Read this: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508houston/index.html