title: Changing datatype of a column in database
body: <p>I have to change the datatype of a column from <code>CHAR</code> to <code>INTEGER</code> in database. I used the following query:</p>
  
  <pre><code>ALTER TABLE cert_request
      ALTER column CERT_REQUEST_NBR SET TYPE(INTEGER);
  </code></pre>
  
  <p>however it's showing error in the keyword "column" and giving the error code as -104 on execution. Following is the error log;</p>
  
  <pre><code>Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ALTER TABLE CERT_REQUEST   ALTER CERT_R;BEGIN-OF-STATEMENT;&lt;create_proc&gt;, DRIVER=3.50.152
  SQLState:  42601
  ErrorCode: -104
  </code></pre>
  
  <p>I also tried the using the <code>Modify</code> keyword, but it isn't identified in my database.</p>
  
  <p>I also tried the following query but again of no use.</p>
  
  <pre><code>alter table CERT_REQUEST alter column cert_request_nbr  integer
  </code></pre>
  
  <p>It gives the following error </p>
  
  <pre><code>Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=integer;umn cert_request_nbr;&lt;alter_col_action1&gt;, DRIVER=3.50.152
  SQLState:  42601
  ErrorCode: -104
  </code></pre>
  
  <p>Please provide me some suggestions.</p>