News & Events – tcACCESS Version 7.0 available

These are some of the highlights of Version 7.0.

 

SQL-support for VSAM/RRDS files

Using the ODBC- or JDBC-interface Open System applications can easily access VSAM RRDS files with no programming effort.

 

Open System Transparency Option:
DB2 UDB and ORACLE as SQL-Engine tables

Mainframe-programs (online or batch) can now directly access a DB2 UDB database without the need to have a DB2 Client available. The same programs can also directly access an ORACLE database. This new functionality greatly enhances the bi-directional data-exchange in complex heterogeneous environments with DB2 and ORACLE.

 

CA-IDMS enhancements

The CA-IDMS-interface has been significantly enhanced in Version 7. CA-IDMS Schema-definitions can now be processed by the import module of the tcACCESS front-end program. Also automatic or manual maintenance of OWNER-MEMBER relationships is fully supported for UPDATE/DELETE and INSERT-functions. 

All information relevant for an efficient access to CA-IDMS will be automatically recognized during the import of CA-IDMS Schema definitions. Last but not least Version 7 also maintains and processes DBKEY-information.

 

Generic Data Server (IO-Exit)

The provision of the IO-exit allows a structured and simple access to data-sources that are home-grown file-systems or file-systems part of a third party software package. The Generic Data Server provides an easy ODBC- or JDBC access (read, write, update).

 

OCCURS- Processing (Virtual tables)

A Virtual table can be used when processing table structures in a record that are either fixed (OCCURS) or variable (OCCURS DEPENDING ON). Virtual table processing can also be used for ADABAS multiple field values or ADABAS periodic groups.
Using a Virtual Table is optional. If not required the standard table strucutre processing of tcACCESS will be used.

 

tcACCESS as WebService

tcACCESS accesses – to all data-sources and stored procedures – can now be used in a WebService. The tcACCESS Webservice service transparently integrates into any existing architecture on an application server and uses the server to exchange messages via SOAP/XML.

 

ORACLE interface in the Front-end program

Using the tcACCESS Front-end program it is now possible to store the result of a SELECT query directly into an ORACLE table.

 

Listener-Enhancements

The functionality of the tcACCESS Listener (PC-workstation component) has been enhanced to provide more efficiency and flexibility for the task processing.

 

Enhancements for ODBC/JDBC

The tcACCESS ODBC-driver is capable of retrieving multiple data-records in a single fetch. In addition it can connect multiple parameter-lines to a single statement. 
This allows for the usage of multiple INSERT/UPDATE/DELETE calls, hence increasing the overall performance.

 

J2EE Connection

The Java 2 platform, Enterprise Edition (J2EE) defines the standard for the development of enterprise applications. J2EE simplifies the development process for enterprise applications because the applications can be built based upon standardized, modular components. J2EE provides a full set of services to these components and independently takes care on a lot of application details with the need for complex programming.

The JDBC driver of tcACCESS Version 7 can be used with application servers that are J2EE compatible. The tcACCESS JDBC driver has been successfully tested with the following application server:

 

 

XML output as UTF-8

Output of XML data can be performed in UTF-8 format. This eliminates conversion errors and enhances the international usage of tcACCESS.

 

Compatibility mode for Stored Procedures

The tcACCESS-SQL Engine now supports a DB2-like execution of Stored Procedures. This requires the definition of all parameters (including output parameter) for a call. The input parameter also become part of the resultset. Existing calls to Stored Procedures do not have to be changed.

 

Enhanced statistical functions

The statistical information captured for SQL-queries have been enhanced. The auditability of mainframe resource utilization has been even more simplified to the benefit of the tcACCESS user.

 

Simple upgrade

In order to use all of the functions of the new tcACCESS mainframe component you must use the client component of tcACCESS Version 7.0. However, it is still possible to use an older mainframe component with the Version 7.0 clients or an older client with the Version 7.0 mainframe components.

 

TOP