DB2 IBM view system names

[Starcomfr]

Hi,

It would be usefull to be able to see system names for tables and columns on DB2 IBM.

Sytem table names can be knownusing request like:
SELECT SYS_TNAME FROM qsys2.systables WHERE TABLE_SCHEMA = 'My_schema' AND TABLE_NAME = 'My_table_name';

System column names can be knownusing request like:
SELECT SYSTEM_COLUMN_NAME FROM sysibm.sqlcolumns WHERE table_schem = 'My_Schema' AND TABLE_NAME = 'My_table_name' ORDER BY ORDINAL_POSITION;

[LonwoLonwo]

Hello @Starcomfr

What issue with the current view system names do you have?

[Starcomfr]

Hello @LonwoLonwo ,

It's not an really an issue but an idea.

As you can see on the screenshot, actually it's only possible to display column names in the view of the table properties.
Therefore a short name exists for column on DB2 IBM witch is created using "FOR COLUMN".

ie:
CREATION_DATE FOR COLUMN CREADET TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP

A short system name for the table is not visible in the table properties using DBeaver

This name is created using 'FOR SYSTEM NAME' as:

CREATE TABLE MY_LONG_TABLE_NAME FOR SYSTEM NAME MYTABNAME (

These informations can be found on IBM system using the request specified in my first message.

[LonwoLonwo]

Ok, maybe we can add this. You can create a ticket: https://github.com/dbeaver/dbeaver/issues/new/choose

[Starcomfr]

Thanks a lot !

Done: Ticket #16102