Re: Synonyms to an SE database
Posted in 2003
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