DB2 > Column names instead of labels | remarks

I'm working on a database that has set the labels and remarks of the columns in its tables. These labels and remarks have the same value for a given column. They can be viewed with the following query:

select t.*
from sysibm.syscolumns t
where
tbname = 'SOME_TABLE_NAME' and
tbcreator = 'SOME_SCHEMA';

When you run a simple `select * from SOME_TABLE_NAME`, the column headers in the result grid are set with the column label/remarks value, instead of the actual underline column name. For example, let's say a column actual name is "CLNT_NAME" and its label and remarks are set to "CLIENT NAME". DataGrip is returning "CLIENT NAME" instead of "CLNT_NAME", and I wasn't able to find an option to toggle this "feature" off.

The same happens when you try to copy a row in the result grid as an insert instruction.

I'd greatly appreciate if you could provide any guidance on how I can instruct the tool to use the actual underline column name, instead of its label/remarks value.

 

Thank you,

Leonardo Braga

0
Avatar
Permanently deleted user

The solution was to add a property `useJDBC4ColumnNameAndLabelSemantics` on the "Advanced" tab of the data source and set its value to `true`. Then the grid column headers, copy as SQL Insert, and other features work as I wanted them to.

0

请先登录再写评论。