SELECT NPAGES, FPAGES, OVERFLOW, CARD INTO :npages, :fpages, :overflow, :card FROM SYSIBM.SYSTABLES WHERE NAME = :table_name
DECLARE C1 CURSOR WITH HOLD FOR SELECT AVGCOLLEN FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = :table_name
OPEN C1
FETCH C1 INTO :avgcollen
CLOSE C1
SELECT CLUSTERRATIO, FULLKEYCARD, NLEAF, NLEVELS, COLNAMES, COLCOUNT INTO :clusterratio, :fullkeycard, :nleaf, :nlevels, :colnames, :colcount FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = :qualifier AND NAME = :index_name
SELECT AVGCOLLEN INTO :avgcollen FROM SYSIBM.SYSCOLUMNS WHERE NAME = :column_name AND TBNAME = :table_name