Re: bulk load
>
> We have Informix Online Dynamic Server V7.13.UC2 running
> on Solaris. Can I do a bulk load (a direct load in
> Oracle7) of an ascii file into Informix? It seems
> that you can't do this with load and dbload. Is this
> correct? We need to load millions of records from an
> ascii file into an informix table. What's the best way
> to do this? Thanks for any help.
> -Duc
> nguyen@ans.net
>
Hi there,
You can certainly load ASCII datafile(s) into table(s) of
Informix database. For better performance you should turn
database logging off (if your database have logging). Use
isql command (load from ascidatafile" insert into mytable)
assuming your database and mytable exist and ascidatafile's
record-fields are pipe separated.
ex:
I) ascidatafile format:
|abc|Apple|Nguyen|123 Address|San Diego|CA|92121|nguyen@ans.net
II) Your table is created by
create table mytable
(
u_ser serial,
login char(8),
fname varchar(30,10),
lname varchar(30,10),
addr varchar(50,30),
city varchar(30,10),
state char(2),
zip varchar(12,5),
email varchar(30,20)
);
III) Also look at your serial key, uniq indexes, database logging status,
your logical logs size.
good luck,
Binh Nguyen