Hi,

Is there any equivalent for Oracle synonym in DB2 ?

Eg :

CREATE SYNONYM test FOR test_tab

Thanks,
Sam

Hi,

You shoud create alias!

Sintax:
Create alias db2admin.test_alias for db2admin.test

Hope this helps,
Grofaty

But you can only do this for Tables and Views.

You CANNOT create a Synonym/Alias for Sequences.

If anyone finds out how then feel free to post the answer.

Hi,

Thanks for your reply. In Oracle, we have 'CREATE PUBLIC SYNONYM', wherein 'PUBLIC' provides the access to all users. How to do this in the 'CREATE ALIAS' query in DB2 ?

Also I tried with 'CREATE SYNONYM' in UDB DB2 8.1v, Its working fine, then what is the difference between 'synonym' and 'alias'

Thanks,
Sam