native sql with explicit syntax "FOR READ ONLY"

[BIsrik]

Hi,

I am reporting on Sybase ASE 15.0.3 using Cognos 8.2 BI. I created a query with few columns from a table and checked the native sql. The native sql at the end had "FOR READ ONLY". This explicit syntax is added to any select statement generated.

The "FOR READ ONLY" is actually creating shared intent locks on the tables and due to this other process is not able to update the table which results in error.

Please let me know where is this setting set to include this syntax in the sqls.

Srik