Re: Open Access for RPG

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

Yep, that would be a perfect example of using ROA.  You should ping ProData
and ask them if they have plans to do that for their product that currently
allows you to connect to remote DB's - though right now without ROA as I
understand it.

Thanks Jon for posting that link.  Will be interesting to see how well ROA
takes off in the non-ISV space.  I think the more people can become
comfortable with the approach, the more likely they are to test the waters.
 Keep the scenario based tutorials coming!

Aaron Bartell
http://mowyourlawn.com
http://mowyourlawn.com/blog/


On Thu, Jul 22, 2010 at 6: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.