In this post, you’ll learn about the error message -126 the select statement contains both an update clause and an order by clause in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-126 the select statement contains both an update clause and an order by clause
Reason for the Error
The SELECT statement in the declaration for a cursor contains both an UPDATE clause and an ORDER BY clause.� An ORDER BY clause cannot be specified in the declaration for a cursor that is to be used for update.
Solution
The implied function is not supported by DB2.� A cursor that is to be used for update cannot be defined to fetch the rows of the object table in a specific order.
