Results 1 to 4 of 4

Thread: synonym ?

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: synonym ?

    Hi,

    Is there any equivalent for Oracle synonym in DB2 ?

    Eg :

    CREATE SYNONYM test FOR test_tab

    Thanks,
    Sam

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    You shoud create alias!

    Sintax:
    Create alias db2admin.test_alias for db2admin.test

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Jan 2004
    Posts
    18
    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.

  4. #4
    Join Date
    Mar 2004
    Posts
    205
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •