×
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.
Il 08/02/2026 14:57, gio.cot via RPG400-L ha scritto:
Hi all
i would need to execute SQL statement (in RPGLE program) that join a IBM i
Table with a MySql table that is stored in a external data base (windows
server) ...
in your opinion is it possbile ??
Thanks in advance
Gio
Is it a one-time deal, or should it be something you can deploy in production
and use every day?
Because these are very, very different scenarios.
However, the partial and short answer is yes: you can read/manipulate data from
databases external to Power Server and other than DB2.
After that, a whole series of factors come into play that can make or break this
solution (network latency, whether it's mission-critical or not, etc.).
Scott Klement's articles on using JDBC drivers have already provided a good
starting point for exploring a solution to your problem.
It could be the ideal solution or something in between, depending on your
specific context.
Another real and concrete solution could be database federation, perhaps even
including a DB2 instance for LUW.
This mailing list archive is Copyright 1997-2026 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
