DB2 Error Code – -538 foreign key name does not conform to the description of the primary key of table table name

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.