title: How do you import a spreadsheet into DB2?
body: <p>I have a CSV file, but this could apply to any txt, data, or xls file.  (xlsx)  I have exported the data from one source and I want to <em>import the data into a DB2 table</em>.  </p>
  
  <p>I first tried <strong>Data Tools Plugin (DTP)</strong> in eclipse Helios (3.6.3) by right clicking on the table and selecting: <strong>Data > Load...</strong></p>
  
  <p>But I got this error:</p>
  
  <blockquote>
    <p>Loading "myschema"."mytable"... com.ibm.db2.jcc.am.SqlException:
    [jcc][10103][10941][4.14.113] Method executeQuery cannot be used for
    update. ERRORCODE=-4476, SQLSTATE=null Data loading failed.</p>
  </blockquote>
  
  <p>Then I tried <strong>Eclipse SQL Explorer</strong> on Eclipse Juno, but it <a href="http://sourceforge.net/p/eclipsesql/discussion/450662/thread/a8645d30" rel="nofollow">does not support data import</a>.</p>
  
  <p>How do I get past this error so I can import?</p>