Subject Deadlock and wait
Author Marcos Vinicius Dufloth
Please, could somebody help me with this?

I start an transaction this way (script running at isql):

set transaction wait isolation level read committed no record_version;

insert ...
insert ...


When running two process or more, I get some few errors:

Statement failed, SQLCODE = -913

-update conflicts with concurrent update

Of course that these inserts are (via triggers) updating same records sometimes, but, if I using WAIT, why this error still generates? Lock manager don't would keep waiting? I missing something?


[Non-text portions of this message have been removed]