title: add new column with not null
body: <p>I am trying to add a new column to a table as below but it is throwing me error.</p>
  
  <pre><code>   ALTER TABLE YBC.POLICY_NON_FIN ADD COLUMN PAY_FREQ CHARACTER(2) NOT NULL;
  </code></pre>
  
  <blockquote>
    <p>[Error] Script lines: 26-27 ------------------------
     In an ALTER TABLE statement, the column "PAY_FREQ" has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL.. SQLCODE=-193, SQLSTATE=42601, DRIVER=3.67.28 </p>
  </blockquote>
  
  <p>So I cannot add not null during alter statement.  Is it mandatory to add as default ?</p>