Hi!

I have a problem - Can anyone help?

I have a requirement to lock a table (to deny all write access to it),
update records in another table, and then to truncate the "locked"
table before allowing access to it.

The problem is that the truncate table issues a commit (which is fine)
but the commit releases my lock and allows queued transactions to
commit BEFORE actionning the truncate (Of it seems to!).

How can I ensure that the truncate table is executed before any other
transactions are committed bu other processes?

TIA