View previous topic :: View next topic
|
Author |
Message |
mail_ssb
New User
Joined: 26 Mar 2005 Posts: 17
|
|
|
|
Hi,
I have a query, wherein, I do a "INSERT...SELECT" to insert into table 'A' immediately after SELECTing from table 'B'. When SELECTing, can I not use 'WITH UR'..? I get error message that UR is not permissible - other isolation levels are allowed.
Any help is appreciated. I did search some DB2 manuals from IBM but could not specifically get information on this topic.
Thanks in advance, for your attention. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I get error message that UR is not permissible |
Quote: |
Any help is appreciated. |
How might we help?
That is not permitted. The manual appears clear - other isolation levels are valid, but not UR. |
|
Back to top |
|
|
mail_ssb
New User
Joined: 26 Mar 2005 Posts: 17
|
|
|
|
Quote: |
How might we help? |
You could help by letting me know which specific DB2 manual you have been referring.
I could not locate this information in the manuals I have been reading. See my previous post. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
You could help by letting me know which specific DB2 manual you have been referring. |
At the top of the page is a link to "IBM Manuals". Among these are several sets of db2 reference manuals.
If you open the SQL Reference (i used v8 as it is most common) and use INSERT SELECT as search criteria (the flashlight/tubelight near the top left of the page), you should get to this page (from the list of hits):
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.74?
If you move down thru that info, you should find this:
Code: |
isolation-clause:
________________________________________________________________________
| |
| >>__WITH__ _RR_ ____________________________________________________>< |
| |_RS_| |
| |_CS_| |
| |
|________________________________________________________________________| |
There is considerably more info/text at that link. . .
Suggest you will be well served by becoming familiar and comfortable with the manuals available from the IBM sites |
|
Back to top |
|
|
mail_ssb
New User
Joined: 26 Mar 2005 Posts: 17
|
|
|
|
Quote: |
There is considerably more info/text at that link. . .
Suggest you will be well served by becoming familiar and comfortable with the manuals available from the IBM sites :) |
Dick, Thanks a ton for your advice and pointing me to the manual.
I have been using IBM DB2 manuals at the "publibz" document library all along. However, often, information on a given topic appears in multiple manuals (SQL REFERENCE, PROGRAMMING GUIDE, COMMAND REFERENCE etc). I may have just missed looking at the right document.
Thanks again. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome
Quote: |
However, often, information on a given topic appears in multiple manuals |
Yup, and where particular info "lives" is not always obvious.
Hopefully, someone here will be able to provide pointers.
Quote: |
I may have just missed looking at the right document. |
From my experience, i've even been in the right manual, but still didn't find what i was looking for because of the way i searched When i get stuck, i ask
Good luck
d |
|
Back to top |
|
|
|