SELECT INDNAME, DEFINER, TABSCHEMA, TABNAME,
COLNAMES, COLCOUNT, UNIQUERULE, INDEXTYPE
FROM SYSCAT.INDEXES
WHERE TABSCHEMA NOT LIKE 'SYS%' AND
TABNAME = 'TABLE_NAME'
COLNAMES, COLCOUNT, UNIQUERULE, INDEXTYPE
FROM SYSCAT.INDEXES
WHERE TABSCHEMA NOT LIKE 'SYS%' AND
TABNAME = 'TABLE_NAME'