When viewing the Indexes built on a Table, the Column name no longer displays if the operating system is v6r1 and above.
 
IBM changed the DATATYPE for field COLUMN_NAME in table SQLSTATISTICS to DBCLOB.
 
I believe the following SQL statement would work to show the COLUMN_NAME, regardless of operating version.
 
SELECT
TABLE_CAT ,
TABLE_SCHEM ,
TABLE_NAME ,
NON_UNIQUE ,
INDEX_QUALIFIER ,
INDEX_NAME ,
TYPE ,
ORDINAL_POSITION ,
cast(COLUMN_NAME as varchar(128)) As COLUMN_NAME,
ASC_OR_DESC ,
CARDINALITY ,
PAGES ,
FILTER_CONDITION
FROM SYSIBM . SQLSTATISTICS
WHERE TABLE_SCHEM = ?
AND TABLE_NAME = ?
ORDER BY 4 , 7 , 6 , 8
 
 
Thanks,
 
Jim