Hi all,
I am getting the follwoing error when executing a simple insert command

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=528, COLNO=0" is not allowed. SQLSTATE=23502


I am not getting what the error is...Also i am not inserting any null value....

Pls help...

Thanks in advance..........

Please post the INSERT statement and the DDL for the table.

Andy

Hi,

The SQL0407N Error help shows the following SQL statement.

SELECT C.TABSCHEMA, C.TABNAME,
C.COLNAME
FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C
WHERE T.TBSPACEID = n1
AND T.TABLEID = n2
AND C.COLNO = n3
AND C.TABSCHEMA = T.TABSCHEMA
AND C.TABNAME = T.TABNAME

If you substitute the values for the TBSPACEID, TABLEID and COLNO shown in the error you will get the column for which a NULL is being inserted.

Then you should be able to trace back to the actual cause of the error.

Regards,
ritz

SQL0407N ??
Do your sql attempt Assignment of a NULL value to a NOT NULL column?

There could also be a trigger on the table that you are inserting into.