Re: Open Access for RPG -- RPG400-L

Vern,

The difference between your product and what I thought could be done
with ROA, is that your product gets and SQL statement from the RPG
program, sends it to the remote DB, receives a result set, then passes
the result set back to the RPG program one row at a time.

Whereas with ROA, I was thinking you couldn't pass the handler an SQL
statement, so it would have to use SQL to get one row at a time from
the remote DB.

Re-reading Jon's article, and the ROA docs, I think you could code the
file USROPN and use the userArea space to pass the SQL statement into
the ROA handler...

So perhaps ROA would provide a good way to access a remote DB after all...

Charles

On Thu, Jul 22, 2010 at 8:58 AM, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:

Charles

Our experience with our product, RPG2SQL Integrator, is that much of the
work done is a few rows at a time. Single-row processing is not an
issue. There isn't usually a large move of data from one box to another
in out typical real-time scenario. One example is combining data from
Oracle with data from the i to put up a web page of a maintenance
schedule. Not a huge data set, in all likelihood.

Vern

On 7/22/2010 7:28 AM, Charles Wilt wrote:

Mike,

While you could certainly do it, I doubt it would be a good idea.

The problem is that ROA is designed for RLA and you'd probably need to
use SQL in the handler to access the remote DB. While SQL can
certainly return 1 record at a time, it wouldn't be very efficient.

Charles

On Thu, Jul 22, 2010 at 7:45 AM, Mike Cunningham
<mike.cunningham@xxxxxxx> wrote:

Could an OA handler be written to allow RPG to access a remote, non DB2, database as if it were a local DB2 table? I would create a local DB2 file that was a duplicate structure of the remote table so the compiler knew what data was in the file. Then at run time the handler would redirect the I/O requests to the remote database. That would be a very nice handler for IBM to provide with this new technology. Or maybe the vendors who sell tools to access other databases from RPG would add this to their suite of products (hint hint)

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Wednesday, July 21, 2010 4:31 PM
To: Rpg400 Rpg400-L
Subject: Open Access for RPG

For those of you who haven't had a chance yet to look at what can be
done with RPG's Open Access in areas other than GUI I/O we just
published our first article on the topic - a simple handler that works
with IFS files. You can find it here: http://www.ibmsystemsmag.com/ibmi/OAR_handlers/33511p1.aspx

Jon Paris

www.Partner400.com
www.SystemiDeveloper.com

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.