Re: Seeing SYNONYM's Listed as Tables

You can create a view on the synonym. The view should be seen (there's a row in systables). create synonym sName for db@server:tabname; create view vName as select * from sName Then, use the view name. Catalin Catalin Badea Senior Technical Architect Tecsys Inc. cat@tecsys.com www.tecsys.com include "disclaimer.4gh" "Friends don't let friends use Oracle products" Roger Meyers <roger@stratsoft.com> wrote in article <32ecd9bd.7045910@area1.news.internex.net>... > Hi! > > I am accessing Informix (On-Line V5) from Powerbuilder, but I suspect > this question would apply to any tool that graphically generates > SQL... (NewEra?) > > I want to use SYNONYM's to make tables in other databases (and other > machines) appear as if they are in the current database so that PB can > access them. This works when I type embedded SQL, but the graphical > SQL painter doesn't see them. Very limiting. > > I suspect this is a PB problem, but I notice that Informix's dbaccess > doesn't show them either. > > Does anyone know of an option that makes SYNONYMs visible to informix > tools? Do the later versions of Informix handel SYNONYMS differently? > > Any suggestions will be greatly appreciated! > > > Roger Meyers > roger@stratsoft.com > > Strategic Software Solutions, San Francisco, CA >