Triggers using Uncommitted Read

[Karl]

Is there any way to make a Trigger use Uncommitted Read?

I want to avoid the possibility of deadlocks in my triggers by setting
them to use Uncommitted Read in all of their Select Stmts.

I get an error when I add WITH UR to the end of select statements in a
trigger - and I tried adding WITH UR to the Trigger definition
aswell... is there anything I can do to force a trigger to use
Uncommitted Read?

[Serge Rielau]

Karl wrote:

Is there any way to make a Trigger use Uncommitted Read?

I want to avoid the possibility of deadlocks in my triggers by setting
them to use Uncommitted Read in all of their Select Stmts.

I get an error when I add WITH UR to the end of select statements in a
trigger - and I tried adding WITH UR to the Trigger definition
aswell... is there anything I can do to force a trigger to use
Uncommitted Read?

See my answer to your other post

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab