Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

REXX DB2 - Isolation level query

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
Hariprasad_Pargunan

New User


Joined: 08 Jan 2009
Posts: 20
Location: Chennai

PostPosted: Fri Feb 05, 2010 9:43 am    Post subject: REXX DB2 - Isolation level query
Reply with quote

Posted: Thu Feb 04, 2010 10:49 am Post subject: REXX DB2 - Isolation level query

--------------------------------------------------------------------------------

Hi,


I have written a REXX DB2 program to fetch few rows from the DB2 tables.

Normally, I use "WITH UR" option in all my select queries. Since in REXX we have an option called
"EXECSQL SET CURRENT PACKAGESET='DSNREXUR'" to set the isolation level I have used the same in my REXX program.

My question is, I am setting the above isolation level before I proceed with the select queries so

1) Will the isolation level "UR" be in effect for all the select queries whatever I use in my REXX code? or

2) We can omit this option and provide "WITH UR" clause in the select queries?

Could you please throw some light on this.
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: Fri Feb 05, 2010 10:31 am    Post subject: Reply to: REXX DB2 - Isolation level query
Reply with quote

Do not post the same question multiple times. . .

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us