In this blog post, you’ll learn more about the Sybase Error FOR UPDATE has been incorrectly specified for a READ ONLY cursor and the reason for receiving this error
Sybase SQL Error Message
FOR UPDATE has been incorrectly specified for a READ ONLY cursor
Reason for this Error
You attempted to declare a cursor FOR UPDATE on a query that is not updatable. Queries that contain DISTINCT, GROUP BY, HAVING, INTERSECT, EXCEPT, or UNION, or that contain aggregate functions are read-only. If the ansi_update_constraints option is on, then queries that contain a join are read-only. If the query references a view then the view may be non-updatable.
