Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010
    Posts
    3

    Unanswered: Create View using "WITH UR"

    I'm not a DB2 person typically, but I was wondering if someone could tell me if creating a view using "WITH UR"? We have a view that is dependent on a long running batch process that is locked several times during the day. The view based on this data does not have to be completely accurate. The batch process we have no control over, so we are looking to alter the isolation level of the view itself.

    Any help would be appreciated,
    Kyle

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you look at the V 9.5 (you did not mention you DB2 version or OS) for LUW documentation, a view is defined as a full-select. The full-select cannot have the isolation clause, only a select-statement.

    Andy

  3. #3
    Join Date
    Jan 2010
    Posts
    3
    They are on 8.something. I'm assuming the same applies?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    That would be correct.

    Andy

  5. #5
    Join Date
    Jan 2010
    Posts
    3
    Great, thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •