Please use SUBJECT in your e-mails.
I agree.
The only use i have found is in SQL or 4GL
programming: i use them for "rename" a table: a
shorter or intuitive name.
--- Dusty Spellman <dustyspellman@hotmail.com>
escribi': > I have been reading up on the Informix SQL
extension
> CREATE SYMONYM, and
> although I understand the mechanincs of a synonym, I
> cannot think of a good
> application for them. Does anyone use them?
>
_____________________________________________________________________________________
> Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com
>
=====
______________________________________Luis Carlos D'az OteroALCANOS DE COLOMBIA S.A. E.S.PCarrera 9 # 7-25Neiva (Huila (Colombia))
_________________________________________________________
Do You Yahoo!?
Obtenga su direcci'n de correo-e gratis @yahoo.com
en http://correo.espanol.yahoo.com
↪ replying to =?iso-8859-1?q?Luis=20Carlos=20Diaz=20Otero?=
The former gentlemen is correct.
Imagine a instance used in a semi oltp way that has batch tables created
every few days, like a billing system .....
Now also imagine that you want only 12 months worth this stuff really
hot, on expensive EMC disks on V class servers, but you still want to be
able to access the older stuff, though seldom.
You could shunt the data into another instance on another machine an old
K perhaps with much cheaper disks and create a synonym across to it.
This gives you the best of all worlds. The data 'appears' to
application like it's local and you get to save hardware costs.
mja
In article <9092kg$17c$1@news.xmission.com>,
=?iso-8859-1?q?Luis=20Carlos=20Diaz=20Otero?=
<luiscarlosdiazo@yahoo.com> wrote:
>
> Please use SUBJECT in your e-mails.
>
> I agree.
>
> The only use i have found is in SQL or 4GL
> programming: i use them for "rename" a table: a
> shorter or intuitive name.
>
> --- Dusty Spellman <dustyspellman@hotmail.com>
> escribi': > I have been reading up on the Informix SQL
> extension
> > CREATE SYMONYM, and
> > although I understand the mechanincs of a synonym, I
> > cannot think of a good
> > application for them. Does anyone use them?
> >
>
________________________________________________________________________
_____________
> > Get more from the Web. FREE MSN Explorer download :
> > http://explorer.msn.com
> >
>
> =====
> ______________________________________Luis Carlos D'az OteroALCANOS DE
COLOMBIA S.A. E.S.PCarrera 9 # 7-25Neiva (Huila (Colombia))
>
> _________________________________________________________
> Do You Yahoo!?
> Obtenga su direcci'n de correo-e gratis @yahoo.com
> en http://correo.espanol.yahoo.com
>
Sent via Deja.com http://www.deja.com/
Before you buy.