Re[2]: SQL Update Table

     Couldn't you create a view joining the two tables together (if like 
     fields exist??) and then execute an update statement?  Perhaps it is 
     worth trying.  
     
     Let me know if it works.
     
     Chris Gonzalez


______________________________ Reply Separator _________________________________
Subject: Re: SQL Update Table
Author:  Dave Mahadevan <mahadevan@fuse.net> at smtp-post-office
Date:    11/19/97 4:55 PM


Michael:
     
Short answer is no.  However, IBM has big plans in V4R2 or something for this. I
guess same time as RUNSQLSTM allows select clauses.  AS/400 SQL is much more 
advanced than Microsoft SQL which allows such nonsense :-)
     
Michael Kenney wrote:
     
>   Does anyone know if it is possible to UPDATE   a field in one table with 
> a value from second table .
>
> TABLEA(MANY)   to  TABLEB(ONE)
> TRANSNO
> CUSNOA       CUSNOB
> ATEXTDATA              BTEXTDATA
>
> I have an 30 byte text field(ATEXTDATA)  and a Numeric Customer# (CUSNOA) 
> in    TABLEA.
> I want to update the ATEXTDATA with some information(BTEXTDATA)  from 
> TABLEB. (CUSNOB) is the  if the KEY.
     
--
Thank You.
     
Regards
     
Dave Mahadevan.. mailto:mahadevan@fuse.net
     
     
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com". 
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---
umidr
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---