MVSFORUMS.com

[zefrim]

Hi all,

perhaps somebody can help me:

i want to show all tables with the sum of the indices per table
and those all in one SQL-Stmt.

Example:


" SELECT creator,name ,"sum(ix)" from sysibm.systables where creator like 'SAPR3%"

RESULT:

creator NAME SUM-INCODES

SAPR3 ATAB 02
SAPR3 DLIB01 13
SAPR3 TECHNX 0
.
.
.

How looks this SQL-Stmt ?

Thanks

Zefrim

[kolusu]

zefrim,

The information you are looking is available in sysibm.sysindexes DB2 catalog table.

try this sql

[zefrim]

thanks it works