Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-23 Thread Timothy Sipples
John, The IBM z/OS Platform for Apache Spark should be available through your Shopz account at no additional charge. Look for 5655-AAB. Only IBM support (5655-AAC) is chargeable, and it's optional. IBM intends to replace the 5655-AAB program number with 5655-OD1 (IBM Open Data Analytics for

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-23 Thread John McKown
Jantje & Timothy, Those look very interesting. But I forgot a critical part in my initial post. The solution must be FREE of any cost or obligation. The z/OS system is being "revitalized", but that doesn't mean that we're going to actually spend any more money on it. Most especially if we already

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-23 Thread Jantje.
On Tue, 22 Aug 2017 07:38:59 -0500, John McKown wrote: >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 Maybe

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-23 Thread Timothy Sipples
John, Here are some more suggestions, in no particular order: 1. IBM InfoSphere Classic Federation Server for z/OS provides JDBC, ODBC, and DRDA access to VSAM data (and other types of data): https://www.ibm.com/us-en/marketplace/infosphere-classic-federation-server Microsoft Excel understands

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread ITschak Mugzach
Try this: Pcomm (and most other emulators) has an api. You an call the send recieve data function from a vb pgm. Now on the mainframe, replace ind$file with a rexx exec that will unload the vsam file ( or load) and call original ind$file pgm to transfer the unloaded data. If you're using ftp, you

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Edward Gould
> On Aug 22, 2017, at 10:08 AM, Lizette Koehler wrote: > > I know about vendor costs. But have you looked at this? > > http://www.connx.com/learning/access_vsam_in_excel.php > > Or other internet searches might bring up other options. > > Accessing VSAM from EXCEL

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Sri h Kolusu
Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 08/22/2017 05:38:59 AM: > From: John McKown <john.archie.mck...@gmail.com> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 08/22/2017 05:39 AM > Subject: thought on data integration: Using MS Excel & MQSeries to > get data from

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 10:53 AM, Doug wrote: > Just a thought, batch job with file manager can create csv format, then ftp > to 'them'. > The reverse should also be possible. > Never tried, just a thought IF you have file manager. > Regards, Doug We have FileAid (old

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Doug
Just a thought, batch job with file manager can create csv format, then ftp to 'them'. The reverse should also be possible. Never tried, just a thought IF you have file manager. Regards, Doug . On Aug 22, 2017, at 08:38, John McKown wrote: would

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 10:08 AM, Lizette Koehler wrote: > I know about vendor costs. But have you looked at this? > > http://www.connx.com/learning/access_vsam_in_excel.php Interesting, thanks! > > Or other internet searches might bring up other options. > > Accessing

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Lizette Koehler
to do this? Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of John McKown > Sent: Tuesday, August 22, 2017 5:39 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: thought on data integration: Using MS Excel

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 8:24 AM, Elardus Engelbrecht wrote: > John McKown wrote: > >>> Can this "massage it in Excel" be determined to program it to just update >>> it on z/OS ?? > >>I doubt it. The actuaries tend to do a lot of what I consider "ad hoc messing

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Elardus Engelbrecht
John McKown wrote: >> Can this "massage it in Excel" be determined to program it to just update it >> on z/OS ?? >I doubt it. The actuaries tend to do a lot of what I consider "ad hoc messing >around" to look at things. Also, they tend to want to "do it themselves" since >none of our

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 8:09 AM, Vernooij, Kees (ITOPT1) - KLM wrote: > 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? I don't think they could do that. The data that they are

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 8:06 AM, Savor, Thomas (Alpharetta) wrote: > I'll state the obvious.. > Can this "massage it in Excel" be determined to program it to just update it > on z/OS ?? I doubt it. The actuaries tend to do a lot of what I consider "ad hoc messing

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Vernooij, Kees (ITOPT1) - KLM
gt; 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 &g

Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread Savor, Thomas (Alpharetta)
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 &a

thought on data integration: Using MS Excel & MQSeries to get data from z/OS.

2017-08-22 Thread John McKown
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