Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Reading VSAM

 
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I am not sure, if this is the correct forum for this query.

My requirement is that i need to read a VSAM file from a web application. What is the best way to go about it?

Thanks in advance
Thara
 
author & internet detective
Posts: 41184
848
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thara,
This question would have been appropriate in either JDBC or WebSphere, so here (JDBC) is fine.

According to IBM, you can access VSAM through a JDBC driver. A couple of those drivers are in this list.
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Wow, that's pretty cool. I've always done it through a COBOL layer either via network protocols like APPC, remote access CICS products or even DB2 stored procedures. The JDBC mapping sounds pretty neat!
 
Ranch Hand
Posts: 2108
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yeah, I will take a look at it too. I might need to access a vsam file from web in one of my current projects.
 
Thara Visu
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Jeanne. That was helpful.

Stan,
Can we update VSAM files through DB2 stored procedures?
 
Stan James
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I never worked directly with that tool ... ConnectDirect or DirectConnect or something. It turned API calls into remote calls to COBOL stored procs. It was my company's "official" way to call mainframe COBOL from remote systems for a while. Back then my project used LU6.2/APPC to great effect and the company now focuses on MQ-Series.
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Jeanne,

IBM's site states the JDBC driver is for a VSE mainframe. Do you know if it will work on a OS/390 mainframe?
 
Jeanne Boyarsky
author & internet detective
Posts: 41184
848
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by RE Poock:
Hi Jeanne,

IBM's site states the JDBC driver is for a VSE mainframe. Do you know if it will work on a OS/390 mainframe?


No idea. In the future, feel free to start a new thread for a new question.

Welcome to JavaRanch!
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic