How can I request VSAM data with Java?

Question

Is there a way (JDBC, Resource Adapter, etc.) to request VSAM data from Java? Do I need to install any solutions on the VSAM system?

If JDBC, what restrictions on SQL are allowed?

Answer 1

One of the answers I found in the search is the IBM VSE Connector, which seems to support JDBC with at least rudimentary metadata and SQL access:

ftp://ftp.boulder.ibm.com/s390/zos/vse/pdf3/vse27/ieswue30.pdf

This solution requires the installation of a VSE connector server on the VSAM side.

Answer 2

Alex, which will work only for VSE - for high-end (for example, z / OS, nee OS / 390, nee MVS / ESA, nee ...), which, in your opinion, may seem useful, this is the API from JZOS Toolkit (Free! - a rarity from IBM ...), which provides its own methods for accessing most basic methods of accessing the mainframe (for example, serial, sectioned, VSAM, etc.).

Links that may be helpful:

• Standalone Java Applications on z / OS Volume I

• Standalone Java Applications on z / OS Volume II

If you want something more specific, I would be happy to help (especially if it was Clojure related ...).

Answer 3

There are products that provide direct ODBC access to VSAM datasets.

Search for an example for ViaSQL.