title: DB2: Insert Query
body: <p>There is table from which I need to select some data based on date criteria which I can do after that need to insert the same data in the same table with the value of one of the columns which is also a key field needs to be changed before insertion. </p>
  
  <p>The Columns of the table are like:</p>
  
  <p>1st key, 2nd key, 3rd key, 4th column,.....26th column, row_update_time, last_upd_user_id, row_create_tm_, row_create_usid.</p>
  
  <p>Now I need to retrieve the data which were updated after a certain date and then insert the same data in this table with a different 2nd key and row_update_time as current time.</p>
  
  <p>I am able to select all the data based on the date criteria and it is retrieving nearly 300 rows. How can I insert with modification in a single shot?</p>
  
  <p>Can any one please help me in this.?</p>