Using Transaction

[Roy Goldhammer]

Hello there

I'm using trasaction to keep a complete query batches together. (if one of
my query faild the entire transaction will be failed)

The transaction (as far as i know) can also lock the tables or the database
while transacion is being made.

I would like to use this option. However the database isn't being locked.

Is there a way to lock the database while transaction is being made?

any help would be useful