×
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 have used this tool and it works pretty well.
Another option if you're in to open-source programming is to use Python, PHP or Node to query the data and return JSON directly to your RPG program to consume. Same with running direct statements against the MYSQL database.
Then you're not beholden to any Java server components or the brittleness of Java embedded in an RPG program.
If you need an example feel free to email me.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
----------------------------------------------------------------------
message: 1
date: Tue, 27 Aug 2024 09:25:57 +0200
from: Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>
subject: Re: DB2 to MySQL
One up for Marks suggestion using Diters solution.
I have used it in many places with great success. It is logging a little too much in my opinion ( each row fetched), but since it is open source, then you can easily change that RPG program and only log negative SQLCODE values... Those is just minor details
it is using a *ARDPGM as a driver. JVAGATE/JDBCGATE is the name and it is great !!
On Tue, Aug 27, 2024 at 4:34?AM Vern Hamberg via RPG400-L < rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
midrange.com
