>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.
I'm not familiar with DB2 but VFP wouldn't know anything about how DB2 works so the setting may be (if there's any) on the DB2 or DB2 ODBC side.
--sb--