To import bulk data in databse in db2

[prodigy201]

Hi,

I am new to db2. And I am trying to import files having bulk data into database. How do we can achieve it? Please guide.

Highly appreciate your help in advance!

Thank you,
prodigy201

P.S - Moreover, I want to know how to import data having separator into it. For e.g data from CSV file etc.

[kleach]

Use the db2 load command. For example

db2 load from data.csv of del append into mytable;

Look up command for other options in the manual. The db2 manuals are very good.

[aba31]

Try this for bulk upload

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002079.htm