What is read-only cursor ?
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 Catalog