× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: UPDATE IN STRSQL USING JOINED FILES
  • From: "David Morris" <dmorris@xxxxxxxxxxxxx>
  • Date: Mon, 02 Aug 1999 17:30:15 -0600

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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.