hi, i need to perform continuos select to find some data, but db2 is returning this cursor with modifications capability and i just need data for read only.
If i use sqlexec(conn,"select * from xtab1 where codigo='001'") then this cursor return in 1 min. aprox, but if i use sqlexec(conn,"select * from xtab1 where codigo='001' for read only") this cursor return in 10 secs aprox. and reading db2 documentation, every select that i use is asumed by read write by db2 and uses more resources from server.
Is there some instruction or "set " command in vfp or db2 to change the way of db2 return the cursor? i need cursor for read only.
Thanks in advace.