Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Question Unanswered: To track the alias name for system DB2 table

    Need to know where to find the Alias names for our DB2 tables. Which particular Catalog tables/source . Also if I contact my DBA will he/she know for sure. Please help. Thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    If it is mainframe, you will find the alias names in SYSIBM.SYSTABLES. Column TYPE = 'A'. Columns TBCREATOR and TBNAME is the name of the base table.

  3. #3
    Join Date
    Dec 2003
    Posts
    4
    Originally posted by Walter Janissen
    If it is mainframe, you will find the alias names in SYSIBM.SYSTABLES. Column TYPE = 'A'. Columns TBCREATOR and TBNAME is the name of the base table.
    Thanks for your reply. It is exact answer we required.

Posting Permissions

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