Re: Re[2]: SQL Update Table

Chris,

In a message dated 97-11-21 02:36:17 EST, you write:

>      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

On any platform _OTHER THAN_ the AS/400 (one of my few gripes).  The AS/400
treats files joined in an SQL statement the same as it does joined logical
files -- no inserts or updates...

IMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"I don't know the key to success, but the key to failure is trying to please
everybody." -- Bill Cosby
+---
| 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
+---