Re: Link to a table on another DB

Posted in 2003

Ferro — Mon, 19 May 2003 18:38:09 +0200 — source: Usenet: comp.databases.informix

> The only thing to watch is SE - no synonyms there. You can achieve > more or less the same effect with links (symbolic or hard), but you > have to be extremely careful. Doing so won't be supported. That > doesn't stop it working, of course. But backups, recovery, etc need > to be thought about. I'm sorry, but I don't understand. What do you mean? Thanks a lot. Ferro.

↪ replying to Ferro

Jonathan Leffler — Mon, 19 May 2003 11:28:18 -0700 — source: Usenet: comp.databases.informix

Ferro wrote: >>The only thing to watch is SE - no synonyms there. You can achieve >>more or less the same effect with links (symbolic or hard), but you >>have to be extremely careful. Doing so won't be supported. That >>doesn't stop it working, of course. But backups, recovery, etc need >>to be thought about. > > I'm sorry, but I don't understand. > What do you mean? I mean that synonyms across databases only work with IDS or XPS or OnLine, not with SE. If your database server is SE, then you have to do other things to achieve the effects of synonyms. -=JL=-