Missing Column Name in "NOT NULL" Error Message

[Spab23]

I have a program that is attempting to do an insert to a DB2 table. When it fails, I get the message:

[IBM][CLI Driver][DB2] SQL0407N Assignment of a NULL value to a NOT NULL column "" is not allowed. SQLSTATE=23502

My problem is I want to know what's in the ""! Does anyone out there know how I can get this info?

Thanks!

 

[Hattusas]

You should send us the SQL;the insert statement of yours.

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[MarcLodge]

Spab23,
Check your sql. If you are fully qualifying all the columns, then check that you have got them in the correct order. Print out a copy of the table layout and the sql and compare the two. You should find your answer that way.
Marc