aspose file tools*
The moose likes JDBC and the fly likes Reading VSAM Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reading VSAM" Watch "Reading VSAM" New topic
Author

Reading VSAM

Thara Visu
Ranch Hand

Joined: May 17, 2005
Posts: 87
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


Thara<br />SCJP 1.4 96%<br />SCBCD 1.3 96%
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
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!


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Jesus Angeles
Ranch Hand

Joined: Feb 26, 2005
Posts: 2057
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

Joined: May 17, 2005
Posts: 87
Thanks Jeanne. That was helpful.

Stan,
Can we update VSAM files through DB2 stored procedures?
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
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

Joined: Jul 19, 2006
Posts: 9
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

Joined: May 26, 2003
Posts: 30762
    
156

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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading VSAM