Re: Generic RPG File Handler for File I/O using OA

Vern Hamburg built one that allowed RLA operations to be used against remote DBs such as Oracle or SQL Server. It was part of a package then sold by RJS - now Help Systems.

Dan Cruikshank when he was with IBM published some sample code which explained the process. The tools he built were sold by IBM Lab Services usually as part of a modernization service but I believe they sold them independently of a service agreement too. Dan has retired from IBM so i don't know if it is still being offered.


Jon P.

On Jun 27, 2022, at 8:06 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

So far I haven't found an
example where I can see how to use them for SQL CRUD operations.

Are you considering writing an ROA handler that intercepts the RPG RLA
operation codes and then dynamically runs SQL equivalents under the covers?
I seem to recall someone on this list doing that some years ago. I seem to
recall some company sponsoring the project to support a security product
they were offering. Maybe Vern Hamberg?
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com