Q: How do I read data without locking the data?

A: General speaking, the select command will lock data in SHARE lock. If you do not want to lock the data, you can use the SELECT ... FOR BROWSE command. This won't do any lock action. It is called a dirty read or browse read.