Re: CREATE SYNONYM suggestions

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