DB2 SQL Show Long and Short Table Names?

Vote count:

0

I've started creating descriptive table names in DB2 and have found DB2 has a short name and a long name for each table.

EmployeePlan has a short name of Emplo00001

I would like to be able to display both names from a sql statement. Here's my existing SQL -- is there a table I can join to in order to get the short name?

select * --table_name, system_column_name, column_text, Type_Name, column_Size, *
from sysibm.SQLColumns
where table_schem IN ('LAWMOD9T', 'LIBDDS')
and upper(table_name) IN ('EMPLOYEEPLAN')
ORDER BY system_column_name

asked 34 secs ago

D. Kermott

25

DB2 SQL Show Long and Short Table Names?