Re: UPDATE primary file with JOIN?

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

>-----Original Message-----
>From: Jack Crouch <j.crouch@ssss.com>
>To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
>Date: Monday, November 15, 1999 2:29 PM
>Subject: RE: UPDATE primary file with JOIN?
>
>
>>Thank you very much.      How about DELETE?
>>
>>DELETE FROM CROUCH/F5501X
>>  (SELECT * FROM PLYDTA/F0101
>>  WHERE WXAN8 = ABAN8)
>>
>
>
>Ahhhhh.  A JDE guy.
>
>No, that's a delete. A delete requires you to specify a record selection
and
>the subselect of * doesn't do it.
>
>It would be more like:
>
>delete from crouch/f5501x where wxan8 = (select aban8 from plydta/f0101)
>
>Note also that this works in V4R2 and prior. It was the update that wasn't
>working.
>
>===========================================================
>R. Bruce Hoffman, Jr.
> -- IBM Certified AS/400 Professional System Administrator
> -- IBM Certified AS/400 Professional Network Administrator
>
>"The sum of all human knowledge is a fixed constant.
>    It's the population that keeps growing!"
>
>
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---