Re: Create synonym on Informix SE 7.22 on Unix

Posted in 2000

Mark D. Stock — Thu, 09 Mar 2000 20:55:28 +0000 — source: Informix-list mailing list archive (1991-1998)

JL wrote: > > Hi, > > I've got two databases on the same database server and I need to create a > synonym between my two databases but when I want to create it, I ever have > an error : 554 syntax disallowed in this database server. > > I've tried many differents syntax but it doesn't work and the > documentation doesn't help me at all. > > Thanks to give me ideas if you can. Well guess what? This syntax isn't supported in SE. You can only create synonyms to local tables. You can create synonyms to remote tables in OnLine or IDS. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+