References: <472789db@newsgate.x-privat.org> <4727af53$1@kcnews01> <472831bf$1@newsgate.x-privat.org>
In-Reply-To: <472831bf$1@newsgate.x-privat.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rchp4.rochester.ibm.com
Message-ID: <47289806$1@kcnews01>
X-Trace: kcnews01 1193842694 129.42.161.36 (31 Oct 2007 14:58:14 +0100)
Organization: Global Network Services - Remote Access Mail & News Services
Lines: 28
X-Complaints-To: abuse@prserv.net
Path: border1.nntp.dca.giganews.com!nntp.giganews.com!ne wscon02.news.prodigy.net!prodigy.net!kcnewsm01.prs erv.net!prserv.net!kcnews01!not-for-mail
Bytes: 1997
Xref: number1.nntp.dca.giganews.com comp.sys.ibm.as400.misc:214672

Richard wrote:
> "CRPence" wrote in message
> news:4727af53$1@kcnews01...
>
>> Then the following update should suffice [if indeed a one-to-one
>> relationship] in that scenario:
>>
>> update F1
>> set (P, Q) = (select R, S from F2
>> where F1.A=F2.C and F1.B=F2.D
>> and (F1.P<>F2.R or F1.Q<>F2.S) )
>> where exists (select 1 from F2
>> where F1.A=F2.C and F1.B=F2.D
>> and (F1.P<>F2.R or F1.Q<>F2.S) )

>
>
> Many thanks Chuck ........ sometimes SQL just isn't as "English like" as its
> proponents make out.
>
> One day IBM will go standard and provide the UPDATE x SET ....... FROM
> ............ WHERE...... construct which is much more "sensible"!
>


Here is a link to DB2 for i5/OS industry standards compliance:
http://publib.boulder.ibm.com/infoce...andardcomp.htm

--
Karl Hanson