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.
