Re: Can you have the same table in two SE databases?

Posted in 2003

Andrew Hamm — Fri, 31 Oct 2003 09:25:16 +1100 — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > >> Doesn't SE support remote synonyms? I'm SURE it does..... > > No. > >> It supports remote database access in the form database:table >> doesn't it, as long as the database can be found in the DBPATH? > > No - you can access remote databases, but you cannot use that notation > in a SQL statement other than a DATABASE statement or a CONNECT > statement. (OK; or ROLLFORWARD or START or CREATE DATABASE). Ahh well. Dare I suggest IDS ?-)