logo  
Google
 

DB2 SQL-Error: -629

SQLState: 42834

Short Description: SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN KEY CANNOT CONTAIN NULL VALUES

The code SET NULL option of the indicated FOREIGN KEY clause is invalid because no column of the key allows null values. The name is the constraint-name specified in the FOREIGN KEY clause or, if a constraint-name was not specified, the first column-name specified in the clause. System action: The statement cannot be processed. Programmer response: Change a column of the key to allow null values or change the delete rule.

 <-  BACK TO INDEX