#599 System i / Power 9 / AS400 - UTF-8 Column Infos

[Claus]

We use a System i / Power 9 / AS400 Database and changed Database Columns to UTF-8 (yes - every single column has to be defined).
This can be read out like the following:

select TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, DATA_TYPE, LENGTH, NUMERIC_SCALE, IS_NULLABLE, IS_UPDATABLE, CCSID
from qsys2.SYSCOLUMNS
where TABLE_SCHEMA = 'ABC'

Is it possible to add Column CCSID to Column Overview, so we can see if it is 1208 (UTF-8) or null (nothing defined / default)
I think if you call it CCSID for every Language - everyone should know what it means as IBM System i Navigator calls it the same.

[Gerd Wagner]

Implemented and will be available in future snapshots and versions.
Please note that the feature requires the DB2 Plugin.

Excerpt from change log:
599 DB2 Plugin: New Object tree details tab "DB2 column details" which for DB2 on AS400 among others shows CCSIDs.

As I don't have access to Db2 for z/OS I the new tab is empty for this DB2 version.

[Claus]

Works fine. Thank you!!