Generix
telephone +44 (0) 1924 500 151
products
evaluation
faq
support
contact
news
home
CONNX for VSAM

CONNX for VSAM provides secure, real-time, read/write SQL access to VSAM files on MVS, z/OS, and VSE using 64-bit and 32-bit ODBC OLE DB JDBC and .NET. In conjunction with other modules, you can perform seamless joins between VSAM and CONNX supported databases.

With CONNX for VSAM a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access.

CONNX performs joins between multiple VSAM files using a single SQL statement, otherwise impossible without custom development, and simplifies manipulation of large arrays through its unique Rotated Array Technology. The CONNX distributed SQL engine uses advanced index optimization to ensure maximum performance when retrieving data from VSAM files.

The CONNX for VSAM distributed SQL engine reduces the workload placed on the mainframe by performing CPU-intensive operations on the client, while allowing the database engine to perform tasks for which it is best suited. This distributed SQL engine facilitates truly scaleable application development because of the additional processing power gained by the use of the client in addition to the database server.

CONNX for VSAM imports the metadata directly from VSAM COBOL copybook into a CONNX Data Dictionary file (CDD). Once, imported, the target VSAM files can be accessed as one or more logical tables or views.

Add CONNX DataSync and replicate your VSAM data to supported data sources without impacting the performance of your VSAM data. CONNX DataSync delivers near real-time data synchronization by incrementally updating only those records that have changed.


Please click on the CD to request an evaluation and realise how your organisation can benefit from using CONNX
overview
architecture
details
case studies
info request
C-ISAM
D-ISAM
DataFlex
DataSync
DB2
Desktop Adapter
OLEDB Adapter
infonaut
informix
microfocus
Oracle
DBMS
Rdb
powerflex
RMS
SQL
Sybase
VSAM