RE: MIS Departmental improvements

Thanks, Dave, for your POV.  Could you expand a bit more on "iSeries folks
(should) take a serious look at migrating many of their applications to DB2
and take full advantage of all it offers"?  I'm not sure I understand how
SQL/DB2 can help us migrate away from our RPG applications.  Or did I read
that the wrong way?

db

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Dave Odom
> Sent: Monday, October 11, 2004 12:54 PM
>
> I think you may be starting to see the benefits of using SQL, and
> hopefully in future DB2/400, and what the language and the engine can do
> for the IS professional and end user.  Besides the "pre-created" joins
> via views, views can provide better security and system resource use,
> provided the base tables have good architecture, indexes and security
> and the views take advantage of those.  In addition, programmers can be
> more productive because they let SQL "match/merge" records into answer
> "sets" must easier and faster than writing an RPG record-at-a-time
> processing program to go through and "touch" each record in each file.
> And, again, this is only the beginning of the benefits.   From the 70's
> until now, IBM and others have been touting the many benefits of SQL and
> DB2, especially on the mainframe, but now, hopefully, more midrange
> iSeries folks will let SQL and the DB2 engine help them get things done.
>    Now this is not to say that SQL and DB2 are the end-all-be-all for
> all problems, but I think it appropriate for the iSeries folks to take a
> serious look at migrating many of their applications to DB2 and take
> full advantage of all it offers.  It will take some re-education and
> perhaps some "mind-adjustment" from the typical native world of the
> iSeries, but it can be done.
>
> Dave
> Arizona