To track the alias name for system DB2 table

lakshmi arvind · #1 (**permalink**) 12-18-03, 04:56

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

Walter Janissen · #2 (**permalink**) 12-18-03, 05:30

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.

lakshmi arvind · #3 (**permalink**) 12-18-03, 06:42

Quote:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech