Hi,
ArdGate is open Source and provides access with normal embedded SQL from RPG
(STRSQL and QMQRY too) to Oracle, MySQL, MS SQL Server and any other database
with a JDBC driver. It supports multiple open files, multiple connections to
different databases in one or multiple jobs at the same time. It has a small
footprint and uses one Java JVM, serving multiple RPG clients using normal
embedded SQL.
It works with interactive STRSQL and you can redirect the output of a select
to a local table, automatically created by DB2/400. It works with QMQRY as
well.
You can download it from SourceForge
http://sourceforge.net/projects/appserver4rpg/
Dieter Bender
Y'all
A couple weeks ago, there was a post
(
http://archive.midrange.com/rpg400-l/201007/msg00212.html) wondering if any
of the vendors might write a handler to get to things like Oracle or SQL
Server using native RPG. I talked with the poster some and got good feedback.
I just want y'all to know that I'm putting together a very simple, basic
handler around our RPG2SQL Integrator product. This isn't a sales pitch by
any means, just want to let you know about it. We don't have anything to sell
yet, anyhow!! This isn't a press release, but it is a statement that we at
RJS Software Systems are looking at this technology.
I support only OPEN, READ, and CLOSE at this time. It can work with only one
file open at a time. But I think it's really cool to have some really clean,
no-nonsense RPG and get data from SQL Server.
My experience so far shows that it isn't all that hard, in principle, to write
a handler. The difficulty comes in working out which op-codes to support, how
to handle multiple open files, all that overhead stuff. Jon Paris has shown
an example of handling multiple open files in his recent article, which I'm
reviewing.
Who knows, it's been suggested that maybe I write an article on this, showing
how I'm doing it.
So I'm throwing this out to y'all.
Vern
midrange.com
