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 CA-IDMS/DB

The tcACCESS SQL Engine provides a direct access to CA-IDMS-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 CA-IDMS with information from other, non-relational mainframe data-sources (i.e. IMS, DLI, DB2, VSAM, ADABAS, CA-Datacom, 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 CA-Datacom-access with automatic use of key-information for an efficient access (CALC Keys or SET key-information)
Support of SELECT, INSERT, UPDATE, DELETE
Transaction-support and 2 Phase Commit
Intelligent import functions for META data from CA-IDMS SCHEMA definitions to obtain table and structure definitions for the relational access
Native SQL-support of the High-Performance Access Technologies of CA-IDMS/DB
Any navigation in the CA-IDMS/DB network is supported (i.e. MEMBER-OWNER-FOLLOWER, MEMBER-OWNER-OWNER (back-chaining)
Support of redefinitions
Support of "Virtual Tables" for record-structures that contain OCCURS and OCCURS DEPENDING ON
Automatic recognition and presentation of key-information
Flexible protection of data because of support of standard security systems (RACF, ACF2 etc.)
Transparent integration of CA-IDMS-data with information from any other data-sources (i.e. PDS/PS, IMS, DLI, DB2, VSAM, ADABAS, CA-Datacom) using standard SQL-commands
Support of data-views for individual or departmental users
Any connectivity method supported (TCP/IP, SNA, MQ-Series, HLLAPI)
Support of DBKEY processing
   

TOP

 

 

 

 

NEWSLETTER

NEWS

CUSTOMERS

EVENTS