-
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.
-
I have no idea, how you have defined the Auto number column...
Try this:
CREATE TABLE EMPLOYEE
(EMPNO INT GENERATED ALWAYS AS IDENTITY,
NAME CHAR(10), SALARY INT,
BONUS INT, PAY INT);
INSERT INTO EMPLOYEE (NAME, SALARY, BONUS, PAY) VALUES('XXXX', 2000, 200, 2200);
INSERT INTO EMPLOYEE (NAME, SALARY, BONUS, PAY) VALUES('YYYY', 5000, 555, 5555);
INSERT INTO EMPLOYEE (NAME, SALARY, BONUS, PAY) VALUES('ZZZZ', 1000, 100, 1100);
SELECT * FROM EMPLOYEE;
EMPNO NAME SALARY BONUS PAY
1 XXXX 2000 200 2200
2 YYYY 5000 555 5555
3 ZZZZ 1000 100 1100
3 record(s) selected.
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
|
|