Hi all,

Do we have a mechanism to implement synonyms (like Oracle synonyms) in DB2.

thanks in advance,
Lahiru

What is your OS??

For z/os, you can use SYNONYM.
For others, you can use ALIAS.

Take a look at SQL reference for syntax.(CREATE ALIAS ...)

Regards
Prakash

Thanx. I already looked into that but it does not serv my purpose. I actually need to access tables without prifixing the schema name for different users.

Two options :
1) Issue the SET SCHEMA in your program
2) Create an ALIAS for each user

The second one is a bit messy if the number of aliases increases (probably, true for ORACLE SYNONYMNs also)

Cheers
Sathyaram

the first solution is out any way. But the second one could u set the alias to users. To my knowledge it only gives another name to the table. For example After adding a alias I still had to access the table with <schemaname>.<aliasname>.

Cheers Lahiru

CREATE TABLE USER1.TABLE1 ...

connect as USER2 :
SELECT * from TABLE1
Error: Table cannot be found .

As a privileged user :
CREATE ALIAS USER2.TABLE1 for USER1.TABLE1

Connect as USER2:
SELECT * from TABLE1
(Selects Rows)

Isn't this you want ?


Cheers
Sathyaram

Ah yes that what I want. Fine I was using the db2 client on Windows it didn't diaplay me the user i wanted. When I ran the the DDL as script with the user I want it fine now. Thanx....