The result field (the total number of rows affected by the SQL statement)of the Dynamic SQL service is not showing the correct count on few occasions.
The SQL statement is as below.
update Table A
set (A.LNID,A.SEQ)= (select distinct B.LNID, B.SEQ ) from Table B
WHERE A.UDMID=B.UDMID AND A.ID=B.ID
WHERE A.SEQ = ? and A.LNID = ? and A.ID=?
On researching what happened at that particular occasion i have noticed that there is an other update/insert statement running on the tables(A and B) with same “ID” at the same time.Can this be the reason?
Can anyone please do let me know how does the record count is calculated by the dynamic sql?
Any help is hugely appreciated.