Could you please guide me, if there is a situation that you did "LOCK ROW FOR ACCESS" on a table initially, but, in one point you dont need to lock the table/row, you just need to do a "Dirty select" like in SQL - WITH (NOLOCK) ... in that case... how do we tackle in TERADATA ?
LOCK ROW FOR ACCESS is the "dirty read" equivalent. So
LOCK ROW FOR ACCESS
select * from yourtab
will give you results even if insert, deletes or updates are ongoing during the same time.