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 Databases

DB2      IMS DL/I      ADABAS      DATACOM      IDMS

SQL access to IMS/DB and DL/I

The tcACCESS SQL Engine provides a direct access to IMS or DLI-databases 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 IMS or DLI-tables with information from other, non-relational mainframe data-sources (i.e. VSAM, 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

 

Dynamic IMS or DLI-access with automatic use of key-information for an efficient access
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
Analysis of PSB- and DBD-definitions to decide access strategy
Support of logical databases and secondary indexes
Support of multiple record-types and segment-structures
Processing of keyed and non-keyed segments
Relational processing of IMS-hierarchies through SQL-commands or IMS Path-Calls
Support of "Virtual Tables" for segment-structures that contain OCCURS and OCCURS DEPENDING ON
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 IMS- or DLI-data with information from any other data-sources (i.e. PDS/PS, VSAM, 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