Re: Future Of DB2 Modernization (Vernon Hamberg)

Hi Mike

Thanks, there is still work to do, although all the opcodes are supported.

It is a single handler for any files opened that have the HANDLER keyword. Performance is an open question, but consider that all the code called by the RPG runtime is replaced by code in the handler, so SOME of it is a wash.

Regards
Vern

On 7/31/2016 11:12 AM, Mike Jones wrote:

Hi Vernon,

Excellent job building that OAR I/O handler, not a simple task. I've been
wondering when sometime would have the need and budget to do so.

If you're at liberty to say, am I correct in assuming that one handler
program (or service program procedure) is required per database table?

Or, did you figure out a way to create a single generic handler that
handles multiple tables? Not that one should do that even if possible, as
I'd anticipate that dynamic SQL would likely be needed and extra overhead
would result. On the other hand, a single handler for multiple tables
would reduce cloning of some of the more complex OAR code via centralizing
it.

Nice work,

Mike