Re: SQL Update Nonsense

[John Carr <74711.77@xxxxxxxxxxxxxx>]

RE:     Re: SQL Update Table

Dave 

By saying M$'s SQL "allows such nonsense", do you mean something as complex
as;

KEY     CHAIN  FILEB                 50
        IF     (*IN50 = *OFF)
        EVAL   FIELDA    =  FIELDB
        UPDATE FORMAT
        ENDIF
?????

Isn't nice to have more than one RDBMS tool at your disposal on a 
given platform?


Dave wrote;
>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 .
+---
| 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
+---