Hi,
I'm asked to execute below query in CICS environement:

Delete from A
where A.COL1 IN
( SELECT B.COL2 FROM
B INNER JOIN C ON COL2
WHERE B.COL3 = C.COL3 )

Please clarify if the DELETE causes locks on tables B and C
in the subquery. If so at what level of data.

Thanks,
Kiran P.

Since this seems to be an exercise, how about giving us some details on what you came up yourself. We can then explain if this is right or not (and why not).