Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  Synonym over SQL table

    Posted 06/14/22 04:30 AM

    Is it possible to create synonym over SQL table not. *All option is not available for object type during creation of new synonym. When select table,view & other objects option then sql table is not showing for selection in synonym creation. Anyone help on above.






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Synonym over SQL table

    Posted 06/14/22 01:34 PM

    I just tested with 2.2.1 and a simple table:

    create table library.test (test_data varchar(256));

    And I was able to find the table both with Object Type "Table" and "Table, Views and Other Objects".

    A few things that could be a problem:

    1. authority
    2. wrong library either specified during the search, or not specified when creating the table and hence created in some arbitrary library
    3. SQL name vs System name as they could be different (e.g. create table library.sql_name for system name sys_name ...)





    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Synonym over SQL table

    Posted 06/15/22 01:59 AM

    Thanks Peter.

    Let me cross check once again.






    #Db2
    #Support
    #SupportMigration