• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading VSAM

 
Thara Visu
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • 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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • 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!
 
Jesus Angeles
Ranch Hand
Posts: 2068
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Thanks Jeanne. That was helpful.

Stan,
Can we update VSAM files through DB2 stored procedures?
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • 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.
 
Rich Poock
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • 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
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic