title: DB2 need help for alter table alter column set data type
body: <p>I need to change the data type of column from <code>VARCHAR</code> to <code>DECIMAL</code></p>
  
  <p>I have data in the column, but they are all numeric values like <code>10.00, 25.50</code> etc,</p>
  
  <p>Now when I do <code>alter table MY_TABLE alter column COL1 set data type to decimal(11,2)</code> its failing. </p>
  
  <p>Whats the process i can follow here.</p>
  
  <p>I'm sure this is not a new question but i couldn't find the solution, so instead of raking my brains i'm asking out here. </p>