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
Can I join tables from different databases?
-
Scott Klement
- Site Admin
- Posts: 969
- Joined: Sun Jul 04, 2021 5:12 am
Re: Can I join tables from different databases?
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.