Re: SQL load or DBLOAD

I just suggest you if you look for the GUI loading tools from Informix. There is a free come with Ver 7. The program is High Performance Loader. The command is onpload which run on X Windows and have GUI to config the loading script Rgds Cecil Carlson@WHSmith wrote in message <358FE083.29C9@bellsouth.net>... >Informix: 7.23.UC4 >OS: HPUX 10.01 > >I'm looking at a partial database reorg this weekend and started looking >at my reorg shell script. I need to shave a bit of time off this >process, as our data has grown considerably. Short of using the >High-Performance Loader (haven't had the opportunity to play with it >yet), which would be faster: > > load from "filename" > insert into table_name> >OR > > DBLOAD -d database -c configfile . . . etc . . > > >BTW: I've seen the new loader . . . but I haven't found a >character-based mode for setup. Is it there, or is it GUI only???? > > >TIA > > > >John Carlson >Informix DBA >WH Smith, Inc.