
How can I create this report?
I have been asked to produce some SQL to produce a report which shows the
name of each table on the database and the number of rows on them so it
should look something like:-
Tablename No of Rows
xxx.aaa_bbb 13
xxx.aaa_ccc 15
etc.
Is there any way that this can be done? I can get the table names from
SYSIBM.SYSTABLES but can't think of way of then putting them into a query to
do a COUNT(*) each table in turn.
Thanks for any help anyone can give.
Gordon.