dbeaver / dbeaver/dbeaver

DB2 with long name and short name together

Open
#37,408 3 comments 0 reactions 0 assignees View on GitHub
x:db2 xf:metadata xf:navigator
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

Hi, i have this problem, i am an RPG programmer on IBM I system using DB2.
I have several tables that have double names, long type for example "INVENTORY_WAREHOUSE_DETAIL" defined through the table creation commands from SQL, and at the same time the short one (max 10 char) defined for example "INWHD0F" by the IBM I system for compatibility with older versions.
So in IBM I can access the same table with both one and the other.
This problem is repeated also within the definition of the table fields here too I can have long and short names.

When in DBeaver I navigate in the list of tables and/or look at the properties of the columns or extract the DDLs I see only the long names.

Is it possible to insert an option that allows you to also see the short names or even better both at the same time.?

best regards

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.