I'm about to start work on a project that will export data from an IBM DB2 dataset and use that data to populate a MSSQL DB.
We have created a small COBOL program to extract this data to delimited format in the past and will probably use something similar for this task.
I'm thinking about using FTP to transfer the data to our MSSQL backend but I'm a little sketchy on the details of how that is normally accomplished due to my infamiliarity of ZOS.
Is there a utility in zos that allows automated connection and transfer to an FTP server? What would be the normal way to accomplish the transfer from zos to the SQL server?
Just a high level explanation should suffice. We will get into details later on.