REORG   jA5YOdDKUSERID  0
INCLUDE SQLCA
BEGIN DECLARE SECTION
END DECLARE SECTION
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
table_name
index_name
qualifier
overflow
fpages
npages
clusterratio
nleaf
nlevels
fullkeycard
colnames
colcount
avgcollen
column_name