BulkInsert on DB2 table from CSV file using C#

Question

0.00/5 (No votes)

See more:

I have a CSV file which has some amount of data for which we are planning to move the data to a DB2 table (its only one time job). So I was planning of something using BulkInsert (sorry if I am wrong as I don't have any knowledge of DB2) through C# code. So please suggest how to write the code in C# to use DB2 bulkinsert functionality, also is it preferable to use the bulkinsert operation or is there any other best possible way. Currently I am thinking of running through each list item and calling insert statement on the table.

Thanks in advance.

Posted 13-Dec-13 3:50am

gettgotcha

Add a Solution

1 solution

Add a Solution

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

bowlturner · Accepted Answer · 2013-12-13T04:23:00

Solution 1

Since this is a one time job looping through might just be the easiest way to do it.

However, with Oracle we have SQLLoader which takes a control file and the data file and will do the work for you. I looked and DB2 has 2 tools that appear to be similar

DB2 LOAD and DB2 IMPORT

Here's a link I found discussing them.
http://www.ibm.com/developerworks/data/library/techarticle/dm-0808khatri/[^]

Posted 13-Dec-13 4:23am

bowlturner

Comments

gettgotcha 13-Dec-13 11:40am

Thank you. Seems like looping is the best option.

bowlturner 13-Dec-13 11:42am

Your welcome. I would suggest eventually becoming familiar with the other tools, they can come in handy.

BulkInsert on DB2 table from CSV file using C#

1 solution

Solution 1

Add your solution here

Preview 0

BulkInsert on DB2 table from CSV file using C#

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us