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   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Hariprasad_Pargunan

New User


Joined: 08 Jan 2009
Posts: 20
Location: Chennai

PostPosted: Thu Feb 04, 2010 10:49 am    Post subject: REXX DB2 - Isolation level query
Reply with quote

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

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Feb 04, 2010 8:27 pm    Post subject:
Reply with quote

Hi Hari,

Quote:
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.


SET CURRENT PACKAGESET is used to specify collection names, it is not even a bit related to isolation levels.

Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Feb 04, 2010 9:05 pm    Post subject:
Reply with quote

sushanth bobby wrote:
Quote:
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.

SET CURRENT PACKAGESET is used to specify collection names, it is not even a bit related to isolation levels.
It is for rexx
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Feb 05, 2010 5:07 pm    Post subject:
Reply with quote

Hari,

Thank You GuyC for that.

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

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

Sushanth
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
This topic is locked: you cannot edit posts or make replies. Need help on If condition continuatio... ashok_uddaraju CLIST & REXX 4 Fri May 19, 2017 8:55 am
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts REXX cdoe to purge a JOB from spool a... Sulabh Agrawal CLIST & REXX 11 Thu Mar 09, 2017 11:36 am


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