What exact error are you getting on the CRTDUPOBJ?
If you use embedded SQL, you won't need the template anyway. Is that an
option?
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
Young i Professionals
http://www.youngiprofessionals.com
dale janus <dalejanus@xxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/22/2009 09:26 AM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
rpg400-l@xxxxxxxxxxxx
cc
Subject
using RPG to access MYSQL files
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
midrange.com
