Hi Expertees,
I executed the query like below
SELECT ATTRIBUTEIDHINT FROM GLOBALPROPERTIES FOR UPDATE
and

UPDATE GLOBALPROPERTIES SET ATTRIBUTEIDHINT=100;

i did not commited or rollbacked and unfortunatly the application is closed .

Next time when i come to the same statement
SELECT ATTRIBUTEIDHINT FROM GLOBALPROPERTIES FOR UPDATE
and

UPDATE GLOBALPROPERTIES SET ATTRIBUTEIDHINT=100;

System is hanging it is not proceding further....

how to solve this one???

Thanks &Regards
Venkata Vara Prasad Kosaraju