DB2 Error Code – -157 view view-name is identified in foreign-key clause

In this post, you’ll learn about the error message -157 view view-name is identified in foreign-key clause in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-157 view view-name is identified in foreign-key clause

Reason for the Error

The indicated object was identified in a FOREIGN KEY clause of a CREATE or ALTER TABLE statement.� A FOREIGN KEY clause must identify a table.

Solution

Correct the statement to specify a table name in the foreign key clause.