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

Hi Justin

Yeah, to me, DB2 means nothing if you don't say which platform - almost as bad as people say they are using SQL when they mean SQL Server. Sigh!

But the rest of the subject does suggest moving to a different flavor of DB2 or a different platform.

Now what I might suggest is a full-fledged open access handler that can speak to whatever database you name - I've done a few iterations of that kind of thing, some minimal operations supported some more extensive.

Then you keep your RPG intact and can still move the data - but why do that, right!

Stay on the i!!!

Regards
Vern

On 1/11/2017 8:52 AM, Justin Taylor wrote:

I interpreted his request to mean that he wanted to replace all his RPG code with SQL running on DB2. Of course, that doesn't make any sense, which is why I didn't comment before.




-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Wednesday, January 11, 2017 7:38 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

Nice outline - and the difficulties are clearly stated.

I do wonder about what the OP meant by "DB2 SQL" - is it to move to a non-IBM i version of DB2, or it it to use SQL embedded in RPG instead of native IO? I don't have the original post in front of me, so I don't know.

IIRC, Fresche Legacy might have some tools to help with either option, I think - I'm not sure about getting off IBM i completely, although maybe their tools can. I do believe there are some refactoring tools that were acquired from Stuart Milligan's suite of products, including X-Analysis.

I'm not promoting any of this, just giving information.

Vern