What is read-only cursor?
A280) A read-only cursor is one in which the result table was created by a query containing one of the following : ·a DISTINCT keyword ·a UNION operator ·a column or scalar function ·a GROUP BY clause ·a ORDER BY clause ·a HAVING clause ·a read-only view in the FROM clause ·a FROM clause identifying more than one table or view DB2® Database Catalog