Re: accessing JDBC database from RPG with embedded SQL

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

Can you point us to some RPG code examples of what this looks like from a
syntax perspective?

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


On Thu, Aug 26, 2010 at 12:54 AM, Dieter Bender
<dieter.bender@xxxxxxxxxxxx>wrote:

> Hi,
> 3 steps to acccess any database over jdbc from STRSQL, QMQRY and embedded
> SQL
>
> - install ArdGate its open Source and available at:
> http://sourceforge.net/projects/appserver4rpg/
> you could choose between runnable jar or running on Tomcat or other J2EE
> compliant WebServer
>
> - add the JDBC database to the remote database directory with ADDRDBDIRE
>
> - install the JDBC driver Archive to ArdGate and provide url and driver
> class
> name
>
> Access the database with normal SQL as any other database in the remote
> database directory.
>
> Its very scalable with high performance, it uses one prestarted JVM to
> serve
> multiple RPG or other native AS/400 clients using my other Java Freeware
> AppServer4RPG (which is extendable for other applications to provide java
> access to RPG)
>
> Dieter Bender
> www.bender-dv.de
>
>
>
> --
> 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.