Re: Using synonyms

> Hello, The only problem is that if the 'funnel' server is down you'll have to scramble to get at the data. Why do you want to do this? What advantage to you see? We access data from different servers in different apps, just use a startup script to set up the correct INFORMIXSERVER value for each. Users run the script rather than the binary. When apps need data from multiple servers we code other environment variables to identify the server or qualified database name for each and either access the data remotely through the initial connected database or using separate connections for each database which tends to be faster (but not worth the coding effort unless the data accessed is extensive). Art S. Kagel > I'm looking for general advice regarding the use of synonyms to > get information from databases residing on other IDS instances (or > even servers)? > Is it a good idea to get data (user information, location informationetc.= > ) > for different applications from one central database using table synonyms= > ? > Does anyone use this approach? Or did anyone try and discard this solutio= > n? > = > > Regards, > Andreas Kutsche > > ------------------------------------------------ > SPAR Oesterreichische Warenhandels-AG > Hauptzentrale > Europastra=DFe 3 > A-5015 Salzburg > = > > Telefon : +43 662 4470 24423 > E-Mail : Andreas.KUTSCHE@spar.at > Internet: http://www.spar.at > ------------------------------------------------ > > = > > > ----LNX_Wed_May_14_2003_18:25:24_V3.33----