Re: using RPG to access MYSQL files

You have to use MySQL drivers
check following link
http://systeminetwork.com/article/jdbc-rpg-enhancements


On Fri, May 22, 2009 at 5:13 PM, dale janus <dalejanus@xxxxxxxxxxxxxxxxx>wrote:

I need help figure out how to use RPG or CL to access MYSQL data created
using the new IBMDB2I engine in MYSQL version.


We have installed the latest version of MYSQL 5.1.34. Then we installed
SUGARCRM with test data. PHPMYADMIN shows the test files using the
new IBMDB2I engine.

We followed the IBM redbook "using ibm db2 for i as a storage engine of
mysql" .Everything seems to have worked as the redbook says it would.
But I am stuck on chapter 4, trying to get to the sugarcrm test files
through rpg.

On page 78, it seems the redbook authors say all I need to do is create
a duplicate object as a file template and compile my rpg program using
it. But CRTDUPOBJ does not seem to know about QSYS2 and other such
things.

I like the idea of creating a dummy duplicate object for RPG compiles.

For example, SUGARCRM has a masterfile called ACCOUNTS (probably lower
case).

We know our catalog name is our I series serial number. The schema
(LIBRARY?)is sugarcrm (in lowercase). The table name is accounts (in
lowercase, probably with " around it).


Can anyone point me in the right direction?

---Dale
--
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.