isql: How to Make List of Tables & Total Rows?

We just got Informix 4.1 Online a week ago so this is definitely a newbie question: How can I make a list of all the tables in a certain database and each table's total rows? Can I do it with one sql statement? Would like output like: table1 <total rows> table2 <total rows> etc. Part of the motivation for listing this info is we have a db with 134 tables...I tried to load the tables with some ascii delimited files...and after an unknown number of successful loads it bombed with improper number of columns...need to isolate which table is at fault, so I can then isolate where "I" went astray. -- +----------------------------------------------------------------------------+ | Greg Sheppard "I use a brute force algorithm of cycling: Peddle| | E-mail: gshep@eskimo.com long enough, and you'll get there." - P. Hickey | +----------------------------------------------------------------------------+