Re: UPDATE IN STRSQL USING JOINED FILES

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Oludare,

The only way I know of on V3R7 is to create a copy of the file and load it 
using a select with join.  Then copy or rename that file.  Best practice is to 
lock the file from update during the time it takes to complete this task.  All 
of this can be performed from SQL, but it is rarely worth it.

David Morris

>>> "oludare" <oludare@ix.netcom.com> 08/02/99 03:20PM >>>
I am on V3R7 and the statement is invalid "bsc4tx is invalid. Valid tokens: + ) 
-"


----- Original Message ----- 
From: Buck Calabro <mcalabro@commsoft.net>
To: <RPG400-L@midrange.com>
Sent: Monday, August 02, 1999 3:11 PM
Subject: RE: UPDATE IN STRSQL USING JOINED FILES


> I am on V4R3 and this works for me:
> update actphy01 set b1u2tx = (select bsc4tx
>  from cusphy01 where bslknb = b1lknb)                                
> 
> More information on SQL programming can be found at:
> http://publib.boulder.ibm.com:80/cgi-bin/bookmgr/BOOKS/QB3AQ802/CCONTENTS 
> 
> Section 5.2 of the V4R3 manual has a lame example of how to do it.  To my
> knowledge, you can't update a JOIN table.
> 
> Buck Calabro
> Billing Concepts Albany, NY
> mailto:mcalabro@commsoft.net 
> 
> > -----Original Message-----
> > From: oludare 
> > Sent: Monday, August 02, 1999 12:38 PM
> > To: RPG AS/400 UserGroup; AS/400 Midrange Usergroup
> > Subject: UPDATE IN STRSQL USING JOINED FILES
> > 
> > How do you change value from a field with value from a field in another
> > file using STRSQL. The two files must be  join with another field for the
> > operation. 


* The Sender's Mail Server is Running An Evaluation Copy of Guinevere.
* Guinevere provides antivirus protection for Groupwise.
* For more information and/or to download your own 30 day 
* evaluation copy, visit http://www.indecon.com/guinevere

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