Unable to Insert New Record
Posted: Thu May 08, 2008 4:14 am
Hello,
I am trying to insert 1 record to an empty table....
and when I run the job I get the following error:
DBMS.CODE=-407, SQLSTATE=23502, [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=7, TABLEID=275, COLNO=7" is not allowed. SQLSTATE=23502
But for example if the record is already in the database and i run the job with the option 'update or insert new records' the job runs successfully...
Any idea why I am not able to insert the record when the table is empty....The data does not have any null values.
Would appreciate any advice
Thanks
I am trying to insert 1 record to an empty table....
and when I run the job I get the following error:
DBMS.CODE=-407, SQLSTATE=23502, [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=7, TABLEID=275, COLNO=7" is not allowed. SQLSTATE=23502
But for example if the record is already in the database and i run the job with the option 'update or insert new records' the job runs successfully...
Any idea why I am not able to insert the record when the table is empty....The data does not have any null values.
Would appreciate any advice
Thanks