The CONNX for VSAM-MVS module provides secure, real-time, read/write access to VSAM data sources on IBM MVS hosts. The CONNX listener program runs as a CICS transactions and waits for client connection requests from ODBC-, OLE DB-, .NET-, or JDBC-compliant programs. In conjunction with other modules, you can perform seamless joins between VSAM-MVS and most other databases.

With CONNX for VSAM-MVS, 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.

The CONNX for VSAM-MVS distributable SQL engine reduces the workload placed on the mainframe by transferring CPU-intensive operations to the Web server or remote user’s desktop. The database calls are low level and minimize impact on the database processor.

CONNX for VSAM on MVS imports VSAM metadata directly from COBOL FD copybooks into a CONNX Data Dictionary. Once, imported, the target VSAM file can be treated as one or more logical tables or views.

CONNX supports real-time CICS TCIP/IP stack and Barnard TCP/IP stack to VSAM files stored on IBM VSE/ESA hosts.

Support for CONNX Rotated Arrays 

Repeating groups in COBOL copybooks defined with the Occurs or Occurs Depending On COBOL syntax can be represented as CONNX rotated arrays.  CONNX will  treat each element of an OCCURS clause as a separate row in a relational result set.