Hi,
I've successfully used the 'For Update Skip Locked' statement in one of my select clause (which I execute in a PROC). As it indicates, it skips the rows that are locked and continues processing with other rows.
Is there a way the get the data (primary key) of the rows that were skipped. I need that information so that I can send email containing all the records (data including primary key) that were lockeed when my procedure was executed...
Please help...
Thanks in advance,
Marc L