Use 1 (one) DB server and create two users "db1" and "db2" who 'own' their database instance. Correct me if I am wrong but the way I unserstood it db1 can then do: select * from db2.table (if you have granted the relevant rights). This has been suggested as the way to work with SAP DB.
Arne
I want to write a dbproc and include it into a database (db1). Within this dbproc several tables from another database (db2) should be selected and/or modified (similar to the Oracle feature "database link": select * from table@db2). How can I access db2 from within db1 in SAPDB?This feature is not available in SAP DB. Daniel Dittmar
-- Institute of Shipping Economics and Logistics http://www.isl.org/ Arne Gehlhaar mailto:[EMAIL PROTECTED] Universitaetsallee GW1 Block A phone:+49.421.22096.49 D-28359 Bremen, Germany fax:+49.421.22096.55 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
