var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: synonym ?
Is there any equivalent for Oracle synonym in DB2 ?
CREATE SYNONYM test FOR test_tab
You shoud create alias!
Create alias db2admin.test_alias for db2admin.test
Hope this helps,
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.
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'