Re: Open Access for RPG

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.