|
View previous topic :: View next topic
|
| Author |
Message |
Arunkumar Chandrasekaran
New User
Joined: 01 Jun 2010
Posts: 63
Location: India
|
|
|
|
Hi ,
I today I happened to a SQL SELECT Query in our system.Please see the query below.
| Code: |
SELECT * FROM tbl_name WITH UR ;
|
Here I couldn't understand what 'WITH' is doing here.I googled but couldn't find WITH in any SQL query.Could some know this explain??
UR - here may be related to table.Actually the table is called User Registration table.
Thanks in advance!! |
|
| Back to top |
|
 |
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| Look up Uncommitted Read in the DB2 Application Programmers Guide. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
Arunkumar Chandrasekaran
New User
Joined: 01 Jun 2010
Posts: 63
Location: India
|
|
|
|
Hi Don & Rohit,
Thank you somuch for the reply.Now I got it.
I should have focused on 'UR' instead of 'WITH'  |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| Its never too late, " Happy learning!!!!" |
|
| Back to top |
|
|
|
|
