title: db2- Set the default value with the next sequence value
body: <p>How I can set the default value for an attribute to be the next value of a squeuence</p>
  
  <p>I tried the following :</p>
  
  <pre><code>ALTER TABLE Person ADD COLUMN ccn VARCHAR(254) default (next value for KAP.CCN_SEQ );
  </code></pre>
  
  <p>And this cause a syntax error</p>
  
  <p>Could you please advice is this doable and if yes what is the correct syntax ?</p>
  
  <p>Thanks in advance.</p>