Page 1 of 1

DB2 bulk load

Posted: Tue Jul 20, 2004 2:40 pm
by kommven
I am trying to bulk load a seq file into DB2 and avoid inserts, can you tell me how to manage this.

Lucky-

Posted: Tue Jul 20, 2004 5:32 pm
by rasi
The question was not clear enough to answer. With DB2 plug-in you can do a full replace to the existing table. There are more options available when you use db2 like insert/update/replace etc. To know more about the options read the db2 bulk load manual.

Thanks
Siva

Posted: Wed Jul 21, 2004 9:43 am
by kommven
I will create a flat file and then bulk load that flat file using a load utility script file.

if any one knows any more information. appreciated

Lucky