Here's the scenario. I issued a select on a table using STRSQL in the green screen. From another session I tried CLRPFM. The command would not run because the member was in use.
However I was able to issue a Delete via iseriesnavigator/run sql scripts.
I would not have expected the select to lock the table/member.
And this just really highlights that I'm not sure I have an understanding of when/why SQL locks records/tables.
We are now defining tables in DDL and extensively using embedded SQL avoiding F specs when possible.
Where do I look for a better understanding of SQL and record locking?