I need to know this for clarity sake.
On another thread, an expert posted that I should use the "WITH UR" clause in my select statement
Where UR equals Uncommitted Read
(Note this was from an issue stating that my SELECT SUM(BAL) FROM ACCT" was not issuing the correct summation, so there may be uncommitted records within the table.
My question is: Will the following command work in BOTH the CLP and the JDBC cclient connection.
SELECT SUM(BAL) FROM ACCT WITH UR
In other words will the JDBC client connection be able to see the unread records as well as the CLP with this command ? (I would think there is a possiblitliy that the CLP could see the unread, but not the JDBC, but I really dont know how this works)