Thread: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION During Insert
View Single Post
  #3 (permalink)  
Old 10-09-07, 06:01
jraveendranath jraveendranath is offline
Registered User
  
Join Date: Oct 2007
Posts: 10
All the Not Null columns in the table are provided values.

Basically, the exact Insert script runs without any errors once the table is Dropped and recreated with the same Structure(Not Null, Null, Default values, PKs & FKs) and Indexes.

And more over, should it not error out with SQLCODE: -407, SQLSTATE: 23502 if a Value is not supplied to a Not Null field?
Reply With Quote