You can use

select cust_code,cust_name
from customer_master
where cust_code = @cust_code with UR

or can use .. "set current isolation UR".....for the session/transaction

This is the min. isolation level you can specify in db2....


-----Original Message-----
From: Vasan Subramanian
[mailto:db2udbdba-ezmlmshield-x17182682.[Email address protected]
Sent: Thursday, October 28, 2004 10:36 AM
To: LazyDBA Discussion
Subject: Reg:- Locks


Hi,

In Sql server, when we write a select on a table, we used to give 'nolock'
on that table so that no shared locks are put on that table.

Like the foll :-
select cust_code,cust_name
from customer_master (nolock)
where cust_code = @cust_code

Is there any approach in DB2 like that ??

Please advise me about how to see the logiacl reads in DB2.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page