Problem:
Microsoft SQL Server readonly cursor locking records without using AUTOCOMMIT
Resolution:
If you want to make the CURSOR read only within a program You can use after the connection is made. This applies before the cursor is open.
EXEC SQL
SET CONCURRENCY READONLY
END-EXEC.
Old KB# 7082
