BULK Insert from a DataTable to DB2

Question

0.00/5 (No votes)

See more:

I have uploaded one excel and extracted the data from excel to the Datatable.
My Datatable Having about 1000 rows. My question is How to Insert entire DataTable into DB2 at once instead of row by row?

Thanks In Advance
Saju

Posted 22-Dec-13 18:14pm

saju A Salim

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vasudevan Deepak Kumar · Answer 1 · 2013-12-22T18:53:00

Solution 2

http://www.ibm.com/developerworks/data/library/tips/dm-0403wilkins/[^]

Posted 22-Dec-13 18:53pm

Vasudevan Deepak Kumar

thatraja · Answer 2 · 2013-12-22T20:14:00

Solution 3

Try DB2BulkCopy Class[^]

Posted 22-Dec-13 20:14pm

thatraja

TrushnaK · Answer 3 · 2013-12-22T18:21:00

Solution 1

refer below link:-

http://stackoverflow.com/questions/10405373/insert-entire-datatable-into-database-at-once-instead-of-row-by-row[^]

Posted 22-Dec-13 18:21pm

TrushnaK

Comments

saju A Salim 23-Dec-13 0:28am

Thanks Trushnak its for SQL Bulk Copy... But it will not work with Db2. My Back end is Db2