I am using IDS 9.40 on a Windows 2000 Server and ClientSDK 2.81 TC3 on a Windows XP Client.
Working with my aplication that uses the c++-API (but also sql-editor or serverstudio) the following Statements lead to a lock on row with id = 2 in tab1, so that another user CAN READ BUT NOT UPDATE this row until commit/rollback:
set isolation to committed read retain update locks;
select * from tab1 where id = 2 for update;
... now edit and update ...
When using ODBC another user ALSO CAN UPDATE the row with id=2! You can try this using MSQRY32.exe on a Windows Client.
How can i reach the same functionality using ODBC as using the c++-API?