DB2 bulk load

kommven · Post by **kommven** » Tue Jul 20, 2004 2:40 pm

I am trying to bulk load a seq file into DB2 and avoid inserts, can you tell me how to manage this.

Lucky-

rasi · Post by **rasi** » Tue Jul 20, 2004 5:32 pm

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

kommven · Post by **kommven** » Wed Jul 21, 2004 9:43 am

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