Re: Re[2]: SQL Update Table

Dean

At 11:48 PM 11/21/97 -0500, you wrote:
>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...

Well, they ARE joined logicals, in a way!

Seriously, maybe this is a more rigorous implementation of the various SQL
standards. Many DBMS's are somewhat lax in their implementations of the
standard. But, then, I don't know for sure.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


+---
| 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
+---