title: How to update table with sequentional on table without primary key?
body: <p>In DB2 on Linux v11.1 I have a table:</p>
  <pre><code>COL1   COL2  &quot;COLn 50 more columns&quot;
  A      A
  A      A
  B      A
  B      B
  etc 3 million rows
  </code></pre>
  <p>There can be multiple rows with the same rows, like first two rows in my sample (so obvious there is no primary key on table).</p>
  <p>Now I have to add new column ID and set for every row unique sequential number.
  The result should be:</p>
  <pre><code>COL1   COL2  &quot;COLn 50 more columns&quot;   ID
  A      A                               1
  A      A                               2
  B      A                               3
  B      B                               4
  etc 3 million rows
  </code></pre>
  <p>How to write such an update statement to update ID column?
  Regards</p>