title: Alter table max length in sql not working
body: <p>I am trying to alter my table <code>ADDRESS</code> for column <code>ADDRESS_TYPE</code> from <code>VARCHAR(10)</code> to <code>VARCHAR(50)</code>.</p>
  
  <p>I tried </p>
  
  <pre><code>ALTER TABLE ADDRESS ALTER ADDRESS_TYPE VARCHAR(50);
  ALTER TABLE ADDRESS MODIFY ADDRESS_TYPE VARCHAR(50);
  ALTER TABLE ADDRESS ALTER COLUMN ADDRESS_TYPE VARCHAR(50);
  ALTER TABLE ADDRESS CHANGE ADDRESS_TYPE VARCHAR(50);
  </code></pre>
  
  <p>none of them work and i got a DB2 SQL error:</p>
  
  <blockquote>
    <p>SQLCODE=-104, SQLSTATE=42601.</p>
  </blockquote>
  
  <p>This table is part of constraint in a few other tables. Trying to get the correct ALTER statement to modify the max length.</p>