10-13-07, 05:28
|
|
Registered User
|
|
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,578
|
|
Quote:
|
Originally Posted by jraveendranath
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?
|
The main issue is that you don't provide us with a full description of the scenario - most preferably with a script to reproduce the error. Your SQL statements simply don't line up...
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
|
|