I was thinking of the opposite obvious question: is the data also needed on z/OS or can they get it just download it and keep it there?
Kees. > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Savor, Thomas (Alpharetta) > Sent: 22 August, 2017 15:07 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: thought on data integration: Using MS Excel & MQSeries to > get data from z/OS. > > I'll state the obvious...... > Can this "massage it in Excel" be determined to program it to just > update it on z/OS ?? > Seems like that would eliminate a bunch of CPU cycles transferring back > and forth and storage to just formally figure out what the "massaging" > is. > > Thanks, > > Tom Savor > Software Developer, Sr > FRMS-SCM > Fiserv > > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of John McKown > Sent: Tuesday, August 22, 2017 8:39 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: thought on data integration: Using MS Excel & MQSeries to get > data from z/OS. > > I have a programmer here who is talking about the subject. What is > happening now is that the Actuarial department is "pestering" him with > requests to extract data from a VSAM cluster (we don't have DB2 on > z/OS), format it into a CSV, so that they can download it and import it > into Excel. They then massage it in Excel, save it as a CSV, upload it > to z/OS, and finally ask the programmer to load the changed data back > into the VSAM cluster. I can imagine the shuddering going on, but this > is _their_ data and not production data. > > Perhaps needless to say, the programmer is getting tired of this. > Also, he is very busy with our revitalization of the z/OS system. He is > familiar with MS VBA. So what he wants to do is to have a VBA program > which can use the Windows MQSeries dll to communicate with a CICS > transaction. This transaction would read or write the data on z/OS from > the data in the Excel spreadsheet. Personally, I don't _do_ Windows, so > I don't know how difficult this would be. But if anyone out there knows > of any examples which might help him code up VBA in Excel with MQSeries, > I would appreciate a pointer. > > Actually, what I tried to push was giving the actuaries a way to > generate an Easytrieve or COBOL program to do what they want, then > submit a job via ftp to do the actual reading or writing of the VSAM > data. We can do this in batch because we have SYSB, which allows a batch > job to update a VSAM cluster via CICS. > > -- > If you look around the poker table & don't see an obvious sucker, it's > you. > > Maranatha! <>< > John McKown > > ---------------------------------------------------------------------- > 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 information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ******************************************************** ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
