Results 1 to 2 of 2

Thread: with ur clause

  1. #1
    Join Date
    Mar 2010
    Posts
    32

    Unanswered: with ur clause

    WITH UR Clause is not working for subqueries in V9.5 but it's working in V9.7
    do you have any documents which states the same or it's an issue in my environment .

    db2 v9.5 fp9 :-
    Code:
    db2 "select count(*) from (select * from t1 with ur ) "
    SQL0104N  An unexpected token "WITH" was found following " ".  Expected tokens
    may include:  " ".  SQLSTATE=42601
    db2 v9.7 fp6 :-
    Code:
     db2 "select count(*) from (select * from t1 with ur ) "
    
    1
    -----------
              7
    
      1 record(s) selected.

  2. #2
    Join Date
    Mar 2003
    Posts
    280
    What's the purpose of specifying isolation level för part of a query?

Posting Permissions

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