Can I join tables from different databases?

Scott Klement's open source interface to using JDBC database drivers from RPG. http://www.scottklement.com/jdbc/
Post Reply
gio.cot
Posts: 15
Joined: Sat May 28, 2022 9:08 pm

Can I join tables from different databases?

Post by gio.cot »

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
Scott Klement
Site Admin
Posts: 969
Joined: Sun Jul 04, 2021 5:12 am

Re: Can I join tables from different databases?

Post by Scott Klement »

I very much doubt that this is possible. Joining is done by the code inside the database engine... you'd need a database engine that understands both databases, and I don't think there is such a thing.
Post Reply