This worked for me.
The update via Logical view didn't work in that I got a message saying
that file could only be open for input.

thanks to all who responded...

Gerald


On 3/5/2012 10:03 AM, Michael Schutte wrote:
update flroutg set flworkc = 9155
where flworkc = 3155 and flprodno in (select bomparnt from bommstr join
ildpf on BOMCHILD = ILDINO where ILDDM1>= .25 and BOMDATEF< 20120305 and
BOMDATDS> 20120305 )


On Mon, Mar 5, 2012 at 10:59 AM, McGovern, Sean
<Sean.McGovern@xxxxxxxxxxxx>wrote:

Would this work for you ?

Create View QTEMP/MYVIEW as
select FLWORKC, FLPRODNO, BOMCHILD
from tfactlib/FLROUTG
join tfactalib/BOMMSTR on BOMPARNT = FLPRODNO join tfactlib/ildpf on
BOMCHILD = ILDINO where FLWORKC = 3155 and ILDDM1>= .25 and BOMDATEF<
20120305 and BOMDATDS> 20120305

Update QTEMP/MYVIEW Set FLWORKC = 9155



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: 05 March 2012 15:54
To: midrange-l@xxxxxxxxxxxx
Subject: turn a select into an update (with multiple joins)

The following SQL returns the list of records I want to update:

select FLWORKC, FLPRODNO, BOMCHILD
from tfactlib/FLROUTG
join tfactalib/BOMMSTR on BOMPARNT = FLPRODNO join tfactlib/ildpf on
BOMCHILD = ILDINO where FLWORKC = 3155 and ILDDM1>= .25 and BOMDATEF<
20120305 and BOMDATDS> 20120305


I want to "SET FLWORKC = 9155"


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].