Re: Accessing DB2 on other platforms with DDM files

[Vance Stanley <w_vance_stanley@xxxxxxxxx>]

 Hi Patrik,
Are you wanting to create an api on the mainframe? in order to call it from the IBM i?
Regards,Vance
    On Monday, September 9, 2024, 07:15:19 AM CDT, Patrik Schindler <poc@xxxxxxxxxx> wrote:  
 
 Hello Vance,

Am 09.09.2024 um 06:40 schrieb Vance Stanley via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

> I Think you have to create a db2 plan on the mainframe. Maybe do a grant to the mainframe db2 table.  Then your sql will need a connect statement: connect to zsystemid userid password;

I already got the (interactive) SQL part to work. I'm specifically asking for DDM files for classic API calls. From gleaning through the Distributed Data Management book, there's a mentioning about CICS and VSAM but not DB2.

> Not sure you can connect ACS to the mainframe. Probably not. 

Just tried. Apparently DB2 there doesn't use the same TCP port for DRDA compared to IBM i.

:wq! PoC