How to generate Alter Table modify next entent size?

Hello, How to generate Alter Table modify next entent size? Currently I've tables with 100+ extents. I've used the following script with dbaccess to display al tables with 100+ extents. select dbsname, tabname, count(*) num_extents from sysmaster:systabnames, sysmaster:sysptnext where partnum = pe_partnum and dbsname = 'baan' group by 1,2 having count(*) > 100 order by 3 desc; Now I want to modify the next extentsizes from these tables. I would like to have a script that produces the following output ALTER TABLE tabname MODIFY NEXT SIZE <current NE_VALUE *2> How do I get this current next extent size? Am I doing the right thing? Do you have a script to does do this? What is the max number of extents for informix tables (pagesize=2k)? I just want to prevent tables from getting to many extents. We are currently setting up a new server, so reducing extents is not an important issue jet. Thanks in advance Greetings, Ditmar den Engelsen -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own