In this post, you’ll learn about the error message -156 the alter table, drop table, lock table or create index statment identifies a view in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-156 the alter table, drop table, lock table or create index statment identifies a view
Reason for the Error
The statements ALTER TABLE, DROP TABLE, LOCK TABLE, and CREATE INDEX apply only to tables.� Indexes can be defined only on tables.
Solution
Verify that the proper name was specified in the statement.
