title: Informix alter/Update table information
body: <p>I am using an informix database, and want to change the value of displayed from 'N' to 'Y'...
  I am running the following sql but seem to be getting a syntax error:</p>
  
  <pre><code>UPDATE tablename 
  SET displayed ='Y' 
  WHERE flag= 'S' OR flag ='DEP' OR flag = 'WTD';
  </code></pre>
  
  <p>I am using or, because in all 3 cases i want the displayed to be Y.
  Any help on correct syntax and how to update or alter the table in informix will be helpful.
  Thanks</p>