title: updating multiple rows of 2 columns with different values (db2 sql)
body: <p>I have a table in which I need to change the values of a couple of columns in multiple rows.</p>
  
  <p>The table with values to be changed is like:</p>
  
  <p><a href="https://i.stack.imgur.com/r0X8T.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r0X8T.png" alt="table structure"></a></p>
  
  <p>The code I have tried containing updated values, with no success, is:</p>
  
  <pre><code>UPDATE &lt;table_name&gt;
  SET (IDENTIFIER_1, IDENTIFIER_2) 
  VALUES (1635, 1755),
         (2024, 2199),
         (1868, 1692),
         (3577, 4825)
  WHERE ID 
          IN ('1', 
              '23', 
              '54', 
              '21');
  </code></pre>
  
  <p>To be honest, I am not sure if this is even supported in db2 SQL. The error is: </p>
  
  <blockquote>
    <ul>
    <li>[Error Code: -104, SQL State: 42601]  DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=update *</li>
    </ul>
  </blockquote>
  
  <p>I should also advise that I am a db2 newbie.</p>