DB2 with long name and short name together
- 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
Assessment
This issue has not been assessed yet.