title: db2 query insert from another table
body: <p>I have a table product(id_product , name );</p>
  
  <p>I have another one: productHistory (id_H , id_product , name);</p>
  
  <p>I wanna create a query (db2) to insert all the rows of product in productHistory;</p>
  
  <p>I have a sequence product_history_seq</p>
  
  <p>I wanna do something like that:</p>
  
  <pre><code>insert into productHistory 
          (id_h ,  , id_product , name) 
    values ( product_history_seq.nextval,..
  </code></pre>
  
  <p>Or,</p>
  
  <pre><code>select (id_product , name) from product
  </code></pre>
  
  <p>What's the correct query? </p>