<html><div style='background-color:'><DIV class=RTE>
<P><BR>Hi Sagar:</P>
<P> I would try to create a cursor with the phrase </P>
<P> " FOR UPDATE OF <column1>, <column2> " in it.</P>
<P>This usually results in a row lock. </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SQL IN MYDB DECLARE XYZ CURSOR &</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-tab-count: 1"> </SPAN>FOR SELECT A, B, C<SPAN style="mso-spacerun: yes"> </SPAN>FROM MYTABLE & </FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="mso-spacerun: yes"> </SPAN>FOR UPDATE OF A, B, C </SPAN></P>
<P><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">The lock is release at commit time.</SPAN></P>
<P><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Regards,</SPAN></P>
<P><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Peter</SPAN></P></DIV></div><br clear=all><hr>Open your e-mail without having to worry about viruses with <a href="http://g.msn.com/8HMBENCA/2737??PS=47575" target="_top">MSN Premium: </a> Join now and get the first two months FREE*</html>