Menu

#7 Multiple connection in PGM

v1.0 (example)
closed
nobody
None
3
2022-05-03
2022-05-03
No

Hi Diter,
in a SQLRPGLE program, how can I do to use 2 connections to 2 different RDBs.
Example: 1 connection to MS-SQL (ARDPGM) and one to DB2 (local).
Thanks.

Discussion

  • Dieter Bender

    Dieter Bender - 2022-05-03

    ... have a look at SET CONNECTION.
    you could switch connections with SQL statement set connection. switching to the local database could be done as well by CONNECT RESET.

    D*B

     
  • Dieter Bender

    Dieter Bender - 2022-05-03
    • status: open --> closed
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.