insert analogue to dbload?

Has anyone seen a utility that does an "insert into table1 select * from table2 where XXXXXXXX" in the same manner that dbload loads from flatfiles? I'm trying to reduce the danger of lock table overflow on inserts and to reduce the possibility of logfile fillup on a long transaction. Specifically, I'd like to have control over the commit interval ala dbload -n and would like to run it from the command line. Sounds like aprogram that lots of people could use. Being the lazy programmer that I am, I wanted to see if anyone else had invented this wheel before I try to write it. Thanks, Joe -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9894 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================