Re: using RPG to access MYSQL files

[Alan Campin <alan0307d@xxxxxxxxx>]

I am confused here.

If you are using the IBM DB2 engine doesn't that just mean that the tables
are just ordinary AS/400 tables which you could access with embedded SQL or
File I/O. (Highly recommend using Embedded SQL so that you break your
program ever time the table gets changed by MYSQL)?

The link provided is to access MySql on another server via Java. I am
hearing that the data is stored on the AS/400 which makes them ordinary
AS/400 tables.

Am I missing something?

If you look in the schema (Library) what do you do see? You should see
physical files and if you display the physical file description you should
see the short and the long name. If the long name is 10 characters or less
you will just see the short name.

You could also look at the schema via Ops Nav.

On Fri, May 22, 2009 at 9:34 AM, Chamara Withanachchi
<chamaraw@xxxxxxxxxx>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.
>
>
> --
> Regards,
>
> Chamara Withanachchi
> IBM Certified Power System Expert
> RPG Programmer
> (owner of www.rpgiv.info)
>
> WWW.RPGIV.INFO
> Mob: +971 50 5698644
> Tel: +971 6 5595887
> chamaraw@xxxxxxxxxx
>
> i want to be future ready. i want control. i want an i.
> --
> 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.