title: How can I drop multiple columns in DB2 on AIX?
body: <p>What is the syntax to drop multiple columns in DB2?  I tried this:</p>
  
  <pre><code>ALTER TABLE work_item DROP COLUMN (TRANSACTION_TYPE, REQUEST_TYPE, LOCATION_CODE, ROLE_ID, SUBMITTED_BY);
  </code></pre>
  
  <p>But it didn't work.  I am running on AIX (from what I read, it looks like maybe you cannot drop columns at all on platforms other than AIX).</p>
  
  <p>If I drop the columns one by one, it seems to work, but after the first three, I need to <code>REORG</code> the table.  I want to do this in one fell swoop, with no REORG.</p>
  
  <p>Is it possible?</p>