title: alter view in SQL DB2, adding new column
body: <p>I have created a view orderedView by ordering by series and values looking like this:</p>
  
  <pre><code>series | values  
       1 | 1  
       1 | 3  
       1 | 5  
       1 | 6  
       2 | -1  
       2 | 0  
       2 | 4  
       2 | 5
  </code></pre>
  
  <p>Now I would like to add a third column to my view, that enumerates each set of series from 1 to the end, like </p>
  
  <pre><code>series | values  | row_ID  
       1 |    1    | 1  
       1 |    3    | 2  
       1 |    5    | 3  
       1 |    6    | 4  
       2 |    3    | 1  
       2 |    6    | 2  
       2 |    8    | 3  
       2 |    9    | 4  
  </code></pre>
  
  <p>I tried with </p>
  
  <pre><code>ALTER VIEW orderedView
      ADD COLUMN ROW_ID INT NOT NULL;
  </code></pre>
  
  <p>but intelliJ says after ALTER VIEW orderedView  "ALTER, DISABLE or ENABLE expected, got 'ADD'"</p>
  
  <p>Is it even possible to alter my view by adding a new column or do I have to add the column before creating the view? And if so, how to do that?</p>
  
  <p>Thanks in advance for any help.</p>