SQL and the "WITH UR" clause

Posted on 2014-07-13
Last Modified: 2014-07-13
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.


Open in new window

 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)

Question by:Anthony Lucia
    LVL 37

    Accepted Solution

    Both will process it exactly the same
    LVL 24

    Expert Comment

    by:Tomas Helgi Johannsson

    I did not suggest you always use  "with ur". Please make sure you understand what that means.
    Reading uncommited data means that your program reads data that is in the process of being changed. If another program (session) is changing data that another reads and then the change is rolled back due to some reason, then the session reading the data will have read wrong status of the data.

         Tomas Helgi

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now