Re: Loading ASCII data

Posted in 1994

Yagnesh — Wed, 16 Nov 1994 17:32:16 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3ac160$9ro@emory.mathcs.emory.edu> daniel@genesis.admin.bethel.edu (Dan Madvig - Bethel College & Sem.) writes: >Anybody know how many locks are used per row when one is loading data >into a table? I'm trying to load 110,000 rows from a pipe-delimited >ASCII file into a table. > If you lock the table in exclusive mode before the load statement, only 2 locks will be used. I am assuming that you have Online 5.xx begin work; lock table so_and_so in exclusive mode; load from "ASCIIfile" insert into so_and_so;commit work; -- Yagnesh M Mehta | ymehta@harriet.rencorp.com REN Corporation USA | (615) 353-4145