Re: Can I join tables from different databases?
Jimmy Sansi <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Just did this using RPG and JDBC using Scott K's tool. Result sets upwards of 10,000+ rows with many columns are surprisingly fast for interactive users looking at the data. Truthfully it is not ideal compared to SQL. But it works and is 100% stable with users hammering it all day. If it was more than a one off I would probably opt for DRDA. On 2026-02-08 05:57, gio.cot via RPG400-L wrote: > 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 -- 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.