I'm trying to insert a new row into a DB2 table using a simple insert statement. I specify all of the collumns and values, but exclude the first column (the auto number field). I was expecting it to add all the fields, and automatically add the incremented value to the autonumber field. Any comments on how to get this working? Here is the error i get:

System.Data.Odbc.OdbcException: ERROR [23502] [IBM][CLI Driver][DB2/6000] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=8, TABLEID=2, COLNO=0" is not allowed.