In this post, you’ll learn about the error message -109 clause clause is not permitted in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-109 clause clause is not permitted
Reason for the Error
The indicated clause is not permitted in the context in which it appears in this SQL statement. A subselect cannot have an INTO clause.� A CREATE VIEW statement cannot have INTO, ORDER BY, or FOR UPDATE clauses.� An embedded SELECT statement cannot have ORDER BY or FOR UPDATE clauses.� SELECT statements used in cursor declarations cannot have an INTO clause.
Solution
Correct the SQL statement.
