title: Using IMPORT instead of LOAD in DB2
body: <p>I wanted to prepare a load utility to load the data into DB2 table. The table has columns which contains GENERATEDALWAYS feature set.</p>
  
  <p>So, I am not able to load an unloaded details from the table.</p>
  
  <p>Is it possible to use import for tables having columns with GENERATEDALWAYS set?</p>
  
  <p>Steps I did:</p>
  
  <pre><code>1. db2 "export to tbl.txt of del modified by coldel| select * from &lt;schema.table&gt; where col=value"
  2. db2 "delete from &lt;schema.table&gt; where col=value"
  3. db2 "import from tbl.txt of del modified by coldel| allow write access warningcount1 insert into &lt;schema.table&gt;"
  </code></pre>
  
  <p>The columns with "GENERATEDALWAYS" is having NEW Value after import. Is it possible to use import to populate GENERATEDALWAYS columns to have the old values?</p>
  
  <p>Appreciate the assistance.</p>
  
  <p>Thanks,
  Mathew Liju</p>