logo Diese Seite zu Mister Wong hinzu
Google
 

DB2 SQL-Error: -407

SQLState: 23502

Short Description: AN UPDATE INSERT OR SET VALUE IS NULL BUT THE OBJECT COLUMN CANNOT CONTAIN NULL VALUES

One of the following conditions occurred: v A null insert or update value was specified for a column defined as NOT NULL. v No insert value was provided for a column that does not have a default value. v A SET transition variable statement specified a NULL value for column defined as NOT NULL. v The insert value was DEFAULT, but the object column was declared as NOT NULL without WITH DEFAULT in the table definition. Consequently, a default value of NULL cannot be inserted into that column. v A null insert value was specified for a ROWID column.System action: The statement cannot be executed. The 'column-name' might be returned in the SQLCA, depending on the syntax of the SQL statement in which the error was detected. Programmer response: Examine the definition of the object table to determine which columns of the table have the NOT NULL attribute or have a type of ROWID, and correct the SQL statement accordingly.

 <-  BACK TO INDEX