Re: Synonyms to an SE database

Posted in 2003

Andy Kent — 1 Dec 2003 02:43:23 -0800 — source: Usenet: comp.databases.informix

I'm not surprised we got misled. I just looked in the 7.3 Syntax Guide for CREATE SYNONYM then followed the link to "Database Object Name" and I can't see anything to suggest that remote synonyms are IDS-specific. It's the same in the 9.4 manual too. Unless I'm missing something ... Andy "Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:<bq31i1$6ar$1@terabinaries.xmission.com>... > Gerry Cassidy wrote: > > andykent.bristol@virgin.net (Andy Kent) wrote in message news:<a3525a11.0311260309.33334379@posting.google.com>... > > > >>Client wants to move a small database onto a Unix box running SE 7.2 > >>and query it through synonyms on the old box. Am I correct in assuming > >>that this still can't be done with an SE server? > >> > >>Thanks > >> > >>Andy Kent > > > > > > Hi Andy > > > > RTFM mate. No, seriously ... you can do this in 7.2. See the chapter > > entitled 'Understanding Informix Networking' in the SQL Tutorial and > > check the piece on Synonym Chains. I think this is exectly what you > > need. Usual syntax, synonyms stored in syssyntable. > > I think you were reading the wrong manual. AFAIK this syntax is not allowed > in SE. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| > | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| > | +-----------------------------------+//// / ///| > | |We value your comments, which have |/// / ////| > | |been recorded and automatically |// / /////| > | |emailed back to us for our records.|/ ////////| > +----------------------+-----------------------------------+-----------+ > > sending to informix-list

↪ replying to Andy Kent

Jonathan Leffler — Tue, 02 Dec 2003 03:47:10 GMT — source: Usenet: comp.databases.informix

Andy Kent wrote: > I'm not surprised we got misled. I just looked in the 7.3 Syntax Guide > for CREATE SYNONYM then followed the link to "Database Object Name" > and I can't see anything to suggest that remote synonyms are > IDS-specific. It's the same in the 9.4 manual too. > > Unless I'm missing something ... The only thing you're missing is (I think) that all the information in the 7.3 guide is only for IDS - there is no SE 7.3 version for it to apply to. I suspect you'd find no SE-only or not-SE marks anywhere in the syntax. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

Andy Kent — 3 Dec 2003 01:36:10 -0800 — source: Usenet: comp.databases.informix

You are right, it is in fact clearly marked in the 7.2 version that the remote stuff is only supported in "OL" (sic). Personally I think it's pretty lame and unhelpful to carve the manuals up like this. Some means of making it more inclusive would have been far more useful - and probably would have avoided this thread! Andy Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<2XTyb.24717$n56.2505@newsread1.news.pas.earthlink.net>... > Andy Kent wrote: > > > I'm not surprised we got misled. I just looked in the 7.3 Syntax Guide > > for CREATE SYNONYM then followed the link to "Database Object Name" > > and I can't see anything to suggest that remote synonyms are > > IDS-specific. It's the same in the 9.4 manual too. > > > > Unless I'm missing something ... > > The only thing you're missing is (I think) that all the information in > the 7.3 guide is only for IDS - there is no SE 7.3 version for it to > apply to. > > I suspect you'd find no SE-only or not-SE marks anywhere in the syntax.