logo  
Google
 

DB2 SQL-Error: -538

SQLState: 42830

Short Description: FOREIGN KEY DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE

The definition of the indicated foreign key does not conform to the description of parent key of the indicated table due to one of the following reasons: v The referenced parent key has not been defined as a primary key or a unique key. v The keys do not have the same number of columns. v The decription of the keys are not identical. The requirement for identical descriptions includes data type, length attribute, and field procedure. 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: Correct the statement so that the description of the foreign key references a primary key or unique key, or so that the description of the foreign key conforms to that of a parent key of the indicated table.

 <-  BACK TO INDEX