Re: using RPG to access MYSQL files

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Chamara

MySQL data using the IBMDB2I engine is stored in iSeries physical files 
- he is not talking about using JDBC at all. No drivers needed. It's a 
new thing. Heard a lot about it at the most recent COMMON.

Regards
Vern

Chamara Withanachchi wrote:
> 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.
> >
> >
> >     
>
>
>