×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
