Bonjour ...
I use since two years now the DB2 JDBC drivers to query some tables on my
OS390 DB2 from my servlets ..and it works fine ..
Like you also I need now to query from my servlets my IMS data and also
some VSAM files which are on the OS 390 ..and it is the problem ..
There are on the market many products very expensive and like ' usine � gaz'
to do that ..
The only product I think good to try is the IBM product Data Joiner :
>From IBM site:
___________________________________
Data Sources Accessed by Classic Connect
Classic Connect provides relational read-only access to IMS databases and
VSAM data sets. It creates a logical, relational database, complete with
logical tables that are mapped to actual data in IMS or VSAM databases.
Specifically:
For IMS, each logical table corresponds to one or more segments of a path in
an IMS full-function database. The fields of multiple segments in a path map
to the columns of a logical table. Each unique set of segment instances for
the given path maps to a row in a logical table.
For VSAM, each logical table corresponds to a VSAM data set. Each field of
the data set maps to a column of the logical table; each record of the data
set maps to a row. Classic Connect can read data from VSAM KSDS, RRDS, and
ESDS data sets.
Using this relational structure, Classic Connect translates relational
queries into DL1 calls or VSAM reads against IMS databases and VSAM data
sets respectively, and returns the result in a relational (for example, a
table) format.
Multiple logical databases can be defined for a single data source (such as
a set of VSAM data sets or a single IMS database). Multiple logical tables
can be defined in a logical database.
Multiple logical tables can be defined for a single data entity (such as a
VSAM data set or an IMS segment). For example, a single VSAM data set can
have multiple logical tables defined for it, each one mapping data in a new
way.
Classic Connect Consists of Four Major Components:
Client Interface Module
Data Server
Enterprise Server
Data Mapper
Client Interface Module
The Client Interface Module is used to establish and maintain connections
with Data Servers and Enterprise Servers. It performs the following
functions:
Determines and loads the appropriate transport layer module, based on
configuration parameters
Establishes communications with Data Servers and Enterprise Servers
Stores and retrieves data in the application storage areas
Presents error and feedback information to the application
The Client Interface Module can establish multiple connections to a Data
Server or Enterprise Server on behalf of a single application program.
The Client Interface Module is contained in both DataJoiner and the sample
applications (DJXSAMP) on MVS, AIX, and Windows NT. The sample applications
are used during initial setup, for testing the configuration, and for
problem determination. They are also useful for designing application
queries.
___________________________________________
[EMAIL PROTECTED]
___________________________________________
Objet : Servlet & JDBC access to VSAM?
>I currently have several servlets that access DB2 using JDBC. I would like
>to add vsam access also. I haven't found a JDBC driver that would allow
>this. Is anyone doing anything like this and have any pointers?
>
>Mark
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
