tcACCESS
  Task
  Technology
  Mainframe Systems
Databases
Mainframe Files
Various
  Workstation Systems

tcACCESS live

How our customers use tcACCESS in production !

more

Ask for a free of charge trial installation.

Tel.: ++49-89-4619930

tcACCESS – Mainframe Files

VSAM      Sequential Files

SQL access to VSAM

The tcACCESS SQL Engine provides a direct access to VSAM-files from different Open System environments or mainframe-platforms using SQL-syntax. Highlight of the tcACCESS technology is the flexibility and transparency. tcACCESS supports the join of information from VSAM-files with information from other, non-relational mainframe data-sources (i.e. IMS, DLI, DB2, ADABAS, CA-Datacom, CA-IDMS, PDS/PS). 

The end-user can use relational data-views that contain all data relevant to him. tcACCESS is responsible for the fast and efficient data-access.

 

Features

 

Support of all VSAM file-types (KSDS, ESDS, RRDS)
Support of SELECT, INSERT, UPDATE, DELETE
Transaction-support and 2 Phase Commit
intelligent import functions for META-data to obtain table- and structure-definitions for the relational access
Support of multiple record-types
Support of "Virtual Tables" for record-structures that contain OCCURS and OCCURS DEPENDING ON
Support of alternate indexes
Automatic detection and presentation of key-information to simplify creation of relations and joins with other data-sources
Flexible protection of data because of support of standard security systems (RACF, ACF2 etc.)
Transparent integration of VSAM-data with information from any other data-sources (i.e. PDS/PS, IMS, DLI, DB2, ADABAS, CA-Datacom, CA-IDMS) using standard SQL-commands.
Support of data-views for individual or departmental users
Any connectivity method supported (TCP/IP, SNA, MQ-Series, HLLAPI)
   

TOP

 

 

 

 

NEWSLETTER

Subscribe B.O.S. Newsletter   

NEWS

tcVISION Version 4 available 

Julius Blum GmbH:
tcVISION moves data between DL/I, DB2 for z/OS and DB2 for LUW 

Vereinigte Informationssysteme Tierhaltung (vit): 
Bi-directional replication between ADABAS and ORACLE 

City of Leipzig: 
Bidirectional integration between IMS and Open Systems 

YAMPONG Corporation: 
the new B.O.S. Software partner in Taiwan 

CUSTOMERS

EVENTS

B.O.S. will present the tcVISION solution for the Real-time Synchronization / Replication of IBM-Mainframe data at the CICS/TS Working Group in Heidelberg from April 21 to 23, 2010 

B.O.S. Software will attend the Spring conference of GSE for z/VSE, z/VM and Linux on System z in Würzburg, Germany from April 19 to 21, 2010 

On December 10, 2009, B.O.S. presented a paper about their IDMS synchronization solution at the IDMS User Group Meeting in Bruxelles. The paper covers areas of bi-directional synchronization of IDMS-data, migration aspects and more