Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
WITH UR in INSERT....SELECT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mail_ssb

New User


Joined: 26 Mar 2005
Posts: 17

PostPosted: Sat Jan 17, 2009 8:48 am    Post subject: WITH UR in INSERT....SELECT
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jan 17, 2009 9:03 am    Post subject:
Reply with quote

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
View user's profile Send private message
mail_ssb

New User


Joined: 26 Mar 2005
Posts: 17

PostPosted: Sat Jan 17, 2009 11:54 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jan 17, 2009 12:07 pm    Post subject:
Reply with quote

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):

http://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 icon_smile.gif
Back to top
View user's profile Send private message
mail_ssb

New User


Joined: 26 Mar 2005
Posts: 17

PostPosted: Sun Jan 18, 2009 9:57 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jan 18, 2009 10:31 am    Post subject: Reply to: WITH UR in INSERT....SELECT
Reply with quote

You're welcome icon_smile.gif

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 icon_confused.gif When i get stuck, i ask icon_wink.gif

Good luck icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us