Re: Batch size for LOAD

Posted in 1998

Jacques P Renaut — Fri, 18 Dec 1998 18:21:02 -0600 — source: Informix-list mailing list archive (1991-1998)

If you are using the dbaccess load command, then there isn't a way to specify a commit interval. But if you have a delimited file that you can use that load command it dbaccess, it should be pretty easy to then use dbload to load it. Dbload does have a commit interval that you can adjust. Jacques Chris Butler wrote: > > Hiya. > > Quick question. I've searched the Informix docs and can't find any info > > on how to set the batch size of the transaction for LOAD. I'm trying to > > avoid "long transaction aborted" issues. Is there a flag or something > to set with LOAD or is this possible? Just want to set it at 1000 rows > a pop or so... > > thanks, > Chris