Hi,

I know that if you want to unlock all records should issue a rollback or commit statement. But what about to unlock one records from a list of records and keep the other records locked. I used the following statement to make the lock for the records:-

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
begin transaction
select item_no,itemdesc
from ims.item [rowlock] with (xlock)
where item_no = '0100100001'

begin transaction
select item_no,itemdesc
from ims.item [rowlock] with (xlock)
where item_no = '0100100002'

Thank's for any help