Re: Can I join tables from different databases?

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.