Re: size of all data in one table

'size' is a relative term. You can get a data size by mutliplying the nrows * rowsize from systables. You can get the number of pages allocated by doing an oncheck -pe | grep tabname | awk '{a+=$3} END {print a}'. More information than that is probably not terribly useful. cheers j. "c.h park" <beast13@cygnus.snu.ac.kr> on 06/12/98 01:44:58 AM Please respond to "c.h park" <beast13@cygnus.snu.ac.kr> To: informix-list@iiug.org cc: (bcc: Jack Parker/Boston50/Epsilon) Subject: size of all data in one table hello. How can I know the total size of data stored in table, named "mytab", current. Is there any sql-type command? or, must create another function which calculate the size? Thanks, in advance.