Re: Accessing DB2 on other platforms with DDM files

Hello Vance,

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

The only way I know to access vsam or Datasets is to create a cobol or sql api on the mainframe. Then you can call it from sqlrpg or cblsql on ibm i.

I see.

Data Sets are basically flat files on the mainframe. Vsam is a little closer to db2 but still you will need a cobol program to read it and pass the info back. You can create programs on the AS400 that can read a DB2 file on the mainframe.

From what I know is that there is no "DB2 file", but probably some kind of VSAM data set as a storage container for the DB2 data structures and actual data.

You can also submit jcl from the AS400.

Yes, also something I eventually want to achieve. This is a sub-function of SNADST on OS/400 and called RJE, while the OS/390 component is NJE: RJE predates SNA.

The "wizard like" setup routine on OS/400 wants to create a separate PU-PU adjacency from scratch, while I want to reuse the existing APPN connection I've established earlier.

I guess I first need to grok the concept of DLUR. This is also a requirement to use STREML3270, which I also fail to get working: No screen output and after a while I'm getting a timeout message. No WTOs from VTAM.

You could ftp a dataset back to the as400 and back to the mainframe.

I know. Goal is to access the data, and not copy things around. :-)

Thanks for your thoughts on this!

:wq! PoC