As far as the Linux side goes, I use python and it's FTP module on the linux server to send files from a user directory on the linux server to the mainframe which is then accessible. Once you do the changes on the mainframe, then you can also use python on the linux server to ftp down the new/changed dataset from the mainframe and have it stored in the user's repository. You could set this up as a cronjob on the linux server so it occurs at specific times, hourly, daily, weekly, or monthly
Thanks, Angel -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Carmen Vitullo Sent: Tuesday, August 16, 2022 9:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Automatic ftp process WARNING: This email originated outside of North Carolina Farm Bureau. DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. CDC IIRC supports DB's other than DB2, on the Mainframe, I worked with a product from Oracle that performed about the same task, running in Unix System Services, it supported Oracle and DB2 IIRC on the mainframe. I forget the product since it's been about 12 years since we did a POC for the product Carmen On 8/16/2022 8:54 AM, Jake Anderson wrote: > It's basically we run a non IBM Database in mainframe > > The user(management) have a list of employees code where they want to > know some of their personal data of employees from mainframe Database. > > So here management or the requestor doesn't have mainframe access and > we as mainframer will pick the list from repository from where they > save and we fetch all the data from Mainframe database and save it > back to the same repository. > > On Tue, Aug 16, 2022, 5:35 PM Carmen Vitullo <petevi...@gmail.com> wrote: > >> any record? any file? >> >> maybe there's some DASD replication tool for this ? we do this for >> DASD subsystems to another subsystem for DR >> >> for Data bases there's IBM's Info-sphere change data capture >> >> Carmen >> >> On 8/16/2022 8:24 AM, Jake Anderson wrote: >>> Hi >>> >>> We have requirement whenever someone saves a record(non-mainframe >>> user) >> in >>> Linux.We automatically wants to get those record and ftp to >>> mainframe and and pull all details from database then save it back >>> to the same location where the user saves his Initial record. >>> >>> Has anyone tried this similar exercise and would like to share your >>> experience or provide me some pointers on where I can start this >>> with >>> >>> Jake >>> >>> -------------------------------------------------------------------- >>> -- For IBM-MAIN subscribe / signoff / archive access instructions, >>> send email to lists...@listserv.ua.edu with the message: INFO >>> IBM-MAIN >> --------------------------------------------------------------------- >> - For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to lists...@listserv.ua.edu with the message: INFO >> IBM-MAIN >> > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN