Re: Accessing VSAM Data from non-zOS platform

2014-10-12 Thread Wayne Bickerdike
Not wishing to denigrate CA-Datacom or VSAMT but the original request was to retrieve data from VSAM. Your proposal would require CA-Datacom, VSAMT, CICS Service Facility. You are proposing a million dollar solution together with the requirement to install and maintain a database with a shrinking

Re: Accessing VSAM Data from non-zOS platform

2014-10-10 Thread Staller, Allan
Correct! Al Staller | Z Systems Programmer | KBM Group | (Tel) 972 664-3565 | allan.stal...@kbmg.com snip Since I'm having some difficulty with the quote option, copy-pasting this content We are currently using JRIO (last supported release will be JAVA7). The replacement is the JZOS Toolkit

Re: Accessing VSAM Data from non-zOS platform

2014-10-09 Thread Govind Chettiar
Since I'm having some difficulty with the quote option, copy-pasting this content We are currently using JRIO (last supported release will be JAVA7). The replacement is the JZOS Toolkit (under application development at this time). The application connects to a JAVA applet on the mainframe.

Re: Accessing VSAM Data from non-zOS platform

2014-10-09 Thread Govind Chettiar
On Tue, 7 Oct 2014 10:39:03 -0400, Bill Ashton bill00ash...@gmail.com wrote: If you need near-time or real-time access to the data, I would recommend you look at CA Technologies product called VSAM Transparency for Datacom/DB. Having used this for a lot of years, it was great. The 20-second

Re: Accessing VSAM Data from non-zOS platform

2014-10-09 Thread Bill Ashton
Well, I am not sure about that document, but we have been z/OS forever, with no VSE. The VSAMT tool allows the VSAM file to be incorporated into the Datacom database environment, and is therefore treated like almost every other database. This means that it is accessible from other mainframe

Re: Accessing VSAM Data from non-zOS platform

2014-10-08 Thread Timothy Sipples
I think we can safely set aside all the file transfer options discussed in this thread as nonresponsive. The original poster specified there's a requirement for live/real-time data access -- that CICS TS, z/OS Batch, and Java programs must all concurrently read and update the VSAM-based data.

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread R.S.
W dniu 2014-10-07 o 03:40, Govind Chettiar pisze: Hello, Would like some insight from people who have tried it on how to get to VSAM data on zOS from non zOS platforms. I didn't search this forum since I wasn't sure what strings to use but a quick google search shows a bunch of products like

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Paul Gilmartin
On 2014-10-07, at 02:49, R.S. wrote: W dniu 2014-10-07 o 03:40, Govind Chettiar pisze: Hello, Would like some insight from people who have tried it on how to get to VSAM data on zOS from non zOS platforms. I didn't search this forum since I wasn't sure what strings to use but a quick

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread R.S.
W dniu 2014-10-07 o 12:01, Paul Gilmartin pisze: On 2014-10-07, at 02:49, R.S. wrote: W dniu 2014-10-07 o 03:40, Govind Chettiar pisze: Hello, Would like some insight from people who have tried it on how to get to VSAM data on zOS from non zOS platforms. I didn't search this forum since I

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Jantje.
On Mon, 6 Oct 2014 20:40:04 -0500, Govind Chettiar rasha...@gmail.com wrote: I didn't search this forum You should have... Any personal experience with these (or other) products would be very useful. Not really personal experience, but some of my colleagues used Websphere Federation Server

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Govind Chettiar
@LISTSERV.UA.EDU] On Behalf Of Govind Chettiar Sent: Monday, October 06, 2014 6:40 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Accessing VSAM Data from non-zOS platform Hello, Would like some insight from people who have tried it on how to get to VSAM data on zOS from non zOS platforms. I

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Staller, Allan
We are currently using JRIO (last supported release will be JAVA7). The replacement is the JZOS Toolkit (under application development at this time). The application connects to a JAVA applet on the mainframe. The data is a VSAM file on z/OS. Both products are no fee licenses available from

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Bill Ashton
If you need near-time or real-time access to the data, I would recommend you look at CA Technologies product called VSAM Transparency for Datacom/DB. Having used this for a lot of years, it was great. The 20-second description is that it allows your application programs to continue accessing the

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread John McKown
On Tue, Oct 7, 2014 at 9:28 AM, Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu wrote: On 2014-10-07, at 07:48, Scott Ford wrote: What about IDCAMS (REPRO) - QSAM - FTP - Other Platform Is REPRO POSIX-pipe savvy? I know FTP is POSIX-pipe (FIFO) savvy. ​Apparently so. I

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Kirk Wolf
! -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Govind Chettiar Sent: Monday, October 06, 2014 6:40 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Accessing VSAM Data from non-zOS platform Hello, Would like some insight from people

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread Paul Gilmartin
On Tue, 7 Oct 2014 10:28:05 -0500, John McKown wrote: and it worked fine. I also did a PRINT INDATASET('SYS1.MACLIB(READ)') DUMP and that worked OK too. What did you try? //OMVSPRT2 JOB 505303JOB,'Paul Gilmartin', // MSGLEVEL=(1,1),REGION=0M //* //USERCOUTPUT JESDS=ALL,DEFAULT=YES, //

Re: Accessing VSAM Data from non-zOS platform

2014-10-07 Thread John McKown
On Tue, Oct 7, 2014 at 11:29 AM, Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu wrote: ​snip of all the code -- gil ​Hum. Interesting. The failure seems to be related to the REXX code in some way SEC6 RSN=801D8018​ ​. Most interesting is the PSW being in key 0! The phrase

Re: Accessing VSAM Data from non-zOS platform

2014-10-06 Thread Lizette Koehler
version of z/OS will it be accessed from? Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Govind Chettiar Sent: Monday, October 06, 2014 6:40 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Accessing VSAM Data from non-zOS platform

Re: Accessing VSAM Data from non-zOS platform

2014-10-06 Thread Paul Gilmartin
On Mon, 6 Oct 2014 18:42:47 -0700, Lizette Koehler wrote: How will you be using the data? LUW, Oracle, other? Do you use NFS or other accesses? You can offload the VSAM with REPRO but then the receiving system would need to be able to read the data. If you could explain the process you will