Progress OpenEdge - how to remove lock from table?
You can use locking hints to select from tables that have locks on them.

select * from tblUser with (NOLOCK) ;


This is ok practice with adhoc sql.

Note Don't use in productioncode without reading and understanding documentation fully.

If you want to kill blocking processes:  http://www.kodyaz.com/articles/identify-kill-blocking-sql-server-processes.aspx