Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

1. change PF/LFs to SQL tables and indexes.

PF/LFs are already SQL tables and indexes, whether they were created with
DDS or SQL DDL. My understanding is that you just need to extract the SQL
DDL to facilitate a migration to another platform.

2. Convert RPG programs to SQL/CLI so that it can be migrated to SQL
Server.

I gather that you mean to convert RPG to SQL PL (Procedure Language), not
SQL/CLI. That's to say you want to end up with SQL stored procedures, user
defined functions, and triggers.

One of the problems with those interfaces in my opinion is that you end up
with just one procedure interface per program. That's essentially the same
as the original program model. Under the ILE model, which I believe is a
better model, you'd probably export multiple I/O procedures and database
event handlers from individual service programs. That's a more efficient
use of resources and less code.

3. Convert RPG reports to Tableu/Cognos/Crystal reports

That leads to server farms.

4. Convert DSPF screens to some frame work like Angular JS

That would mean a total rewrite. Display files do not "convert" to Angular
containers. You're talking about replacing a DSPF (record-write /
record-read) paradigm to a single page app paradigm.

5. Migrate everything to another platform/cloud..(if there is a need)

It's hard for me to see any sense in that. I get the feeling that you're
pursuing a "silver bullet":

http://bit.ly/2iqiWby