On Fri, 2002-07-26 at 02:54, Marc Lavergne wrote:
> Like you said, it's really just a symlink for db objects. If memory
> serves me right, synonyms can only refer to tables and views in Oracle.
> The most common use is for simplifying access to objects outside your
> schema (eg. create synonym TABLEX for JOHN.TABLEX) or for simplifying
> access to objects across database links (eg. create synonym TABLEX for
> TABLEX@DBY).
For quick answers on SYNONYM use in DB2 see
http://members.aol.com/cronid/db2.htm
(search for synonym)
I found no SYNONYM in SQL99 but for a similar construct ALIAS, there is
a reserved word in SQL99, but I could find no definition using it.
----------------
Hannu