Re: SQL Update Nonsense

[Dave Mahadevan <mahadevan@xxxxxxxx>]

John:

MS SQL does not do RPG Chain.  But something similar to your logic is available 
under
most RDBMS (like Oracle, Access, FoxPro, MS SQL etc.)

John Carr wrote:

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



--
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 MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---