title: How to AUTO_INCREMENT in db2?
body: <p>I thought this would be simple, but I can't seem to use AUTO_INCREMENT in my db2 database.  I did some searching and people seem to be using "Generated by Default", but this doesn't work for me.   </p>
  
  <p>If it helps, here's the table I want to create with the sid being auto incremented.</p>
  
  <pre><code>  create table student(
        sid integer NOT NULL &lt;auto increment?&gt;
        sname varchar(30),
        PRIMARY KEY (sid)
        );
  </code></pre>
  
  <p>Any pointers are appreciated.</p>