Re: Gotchas while migrating from DB2 to Oracle.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 10 Dec 2003 08:46:53 -0800
Message-ID: <1071074846.294830@yasure>

Comments in-line.

Noons wrote:

> Hemant Shah <shah_at_typhoon.xnet.com> wrote in message news:<br590p$12d$1_at_flood.xnet.com>...
>
>

>>  was pretty lively. It seems Oracle will not block readers, and that
>>  difference (from DB2) has significant impact on our application. 

>
>
> It should not cause major problems. If the functionality of Oracle
> is a problem (why?), then use SELECT ... FOR UPDATE as the syntax
> for your "block-on-read" implementation. It will achieve the same
> result.

Welcome back but you missed the beginning of this thead. What he wants can not be accomplished with FOR UPDATE.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Dec 10 2003 - 10:46:53 CST