Re: Limit UPDATE statements to affect only one row

DA Morgan wrote:
> I often find using a valid syntax improves things in Oracle.
> Perhaps that isn't required with DB2.
>
> UPDATE (
> SELECT sal
> FROM emp)
> SET sal = 1
> WHERE rownum = 1;

*sigh*I give up. It's like discussing Kant with my cat. All I ever get is Meaow!

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/