We use jt400 in newest Version to connect to a System i / AS400 Database 7.3
I use SQuirreL 4.2.0 or current snapshot. I have loaded DB2 Plugin.
When I open Index-Tab i see only
<Unbekannt(2.011)>
for Index-Columns.
If I have one index, i get two lines like these:
| Header | Header | Header |
|---|---|---|
| Cell | Cell | Cell |
| Cell | Cell | Cell |
| INDEX_QUALIFIER | INDEX_NAME | ORDINAL_POSITION | COLUMN_NAME | ASC_OR_DESC | NON_UNIQUE | TYPE | CARDINALITY | PAGES | FILTER_CONDITION |
|---|---|---|---|---|---|---|---|---|---|
| schema | FC_BLOBS | 1 | <Unbekannt(2.011)> |
A | 0 | 3 | <null> |
<null> |
<null> |
<null> |
<null> |
<null> |
<Unbekannt(2.011)> |
<null> |
<null> |
0 | 670724 | 437480 | <null> |
Fix is committed to our GIT repository and will be available in future snapshots and versions.
Excerpt from change log:
1482 DB2 fpr AS400 driver version 10.6/12.6 Index name were not displayed.
Note: As the driver changed the SQL type of the index name meta data column to NCLOB
in File --> Global Preference --> tab "Data Type Controls" the "Read contents" checkbox must be checked.
That the driver now returns index names as type NCLOB may also be considered a problem with the driver.