In this post, you’ll learn about the error message -538 foreign key name does not conform to the description of the primary key of table table name in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-538 foreign key name does not conform to the description of the primary key of table table name
Reason for the Error
The code is used to report that the definition of the indicated foreign key does not conform to the description of the primary key of the indicated table. Either the keys do not have the same number of columns or their descriptions are not identical. The requirement for identical descriptions includes data type, length attribute, and field procedure.� 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.
Solution
Correct the statement so that the description of the foreign key conforms to that of the primary key of the indicated table.
