View Single Post
  #2 (permalink)  
Old 10-09-07, 03:58
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Posts: 2,298
As we told you in the other newsgroup already: you have 5 NOT NULL columns (w/o defaults) in the table and assign only values for 4 of them. Unless you have some triggers in the picture that assign a value to the remaining NOT NULL columns, the above statement cannot work.

In short, we would need the complete DDL of all objects associated with the table and the INSERT statement.
__________________
Knut Stolze
Smart Analytics Optimizer
IBM Germany Research & Development
Reply With Quote