Re: Can I join tables from different databases?
Luca Giammattei <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
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 is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.