title: How to update multiple rows with the same sequence value
body: <p>I'm using DB2 and want to update several rows that meet my condition with the same next value from my sequence.
  Here is what I tried but this doesn't work as the next value is fetched for each row:-</p>
  
  <pre><code>update dependency dep set vid=NEXT VALUE FOR seq_VID where id in ('8371','8372','8373')
  </code></pre>
  
  <p>id is the the primary key and seq_VID is a sequence. So what I had hoped was that say the next sequence value was 99, that 99 would be set for all 3 rows (and not 99,100,101 as is the case with this).
  My workaround is to break it into separate statements for each id in my list, i.e.</p>
  
  <pre><code>update dependency dep set vid=NEXT VALUE FOR seq_VID where id= ('8371')
  update dependency dep set vid=PREVIOUS VALUE FOR seq_VID where id= ('8372')
  update dependency dep set vid=PREVIOUS VALUE FOR seq_VID where id= ('8373')
  </code></pre>
  
  <p>But I'd like to execute this in one SQL statement if possible - any ideas?</p>