RE: update with select in sql

On Fri, 30 Aug 2002, Joe Pluta wrote:

> Just a quick question... is there a reason NOT to do this in RPG?  Even if
> the appropriate logicals didn't exist, it seems it would be easier and more
> straightforward to create a couple of temporary logical views or OPNQRYFs
> and then run a simple four or five line RPG program.

Three reasons:

1.  It should be really easy - even easier than writing the teeny RPG
program.  No compile, no temp files, no nothin' - just do it.
2.  Because I want to learn how to do it in SQL.  If I learn how to do it
now, I will be able to realize the time savings indicated in reason 1.
If I don't, I will never be able to save that time.
3.  Because as the famous mountain climber Mallory said, "Because it's
there."

James Rich