-
Auto Number troubles
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|