News & Events – tcACCESS Version 8.0 available

These are some of the highlights of Version 8.0:

 

The tcACCESS Global Language

The tcACCESS Global Language Pack enables the tcACCESS SQL-Engine to use multi byte and double byte code tables. Nearly all available characters can be used as part of the SQL statements and as part of the returned data. Data stored in a data source that is being processed by tcACCESS can now be queried and maintained based upon their required code table. Every field of a table can be assigned to a unique CCSID. The data of the field are interpreted based upon this CCSID.

 

UTF-8 coding of output files

tcACCESS Version 8.0 generally uses the UTF-8 character set to create output files of format "XML, structured text files and preview" for transfer type „Host SQL-Query“.

 

ODBC driver as UNICODE driver

With Version 8 two ODBC driver will be distributed: an ANSI driver for compatibility reasons and a UNICODE driver. When the tcACCESS Global Language Pack is used it is strongly recommended to use the UNICODE driver.

 

Open System Transparency Server component (Option*)

The new tcACCESS component supports the access to databases that become more and more important in the area of PCs and UNIX workstations. The component consists of a new server that has been designed to work closely with the tcACCESS SQL-Engine like any other of the tcACCESS data servers. The OST server represents a reliable, stable and fine performing partner to the SQL-Engine in an Open System environment. The server enables the tcACCESS SQL-Engine as well as other host programs to directly access ODBC data sources, DB2/UDB databases via DRDA and Oracle.

 

SQL Profiler

In today's IT environment it is becoming more and more important to execute SQL statements in the fastest and most efficient way. At the same time the impact on the mainframe must me minimized. To accomplish this, it is mandatory to have detailed information about the applications used and their data accesses. Only if these information is available and understood existing applications can be optimized. 
 
tcACCESS Version 8 contains a powerful tool that helps in the analysis process of SQL statements. The tool contains enhanced functions that assist in the analysis of the executed queries and helps to improve the performance of the applications.

Using the access statistics and the information provided applications and queries can be identified over a period of time that have potential for improvements. The access type is one criteria but not the only one, also the frequency of the queries is an important factor that must be considered for the overall performance improvement. The current version of tcACCESS provides easy to understand graphics as well as detailed information about every part of the access and about the access efficiency.

 

Enhanced statistical information

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.

 

Stored Procedure GUI

There is a new implementation of the mechanism to call existing programs without the need to have an adapter program to maintain the Commarea formats. A comfortable importing tool and an editor has been provided to import the Commarea structure. Default values can be defined, multiple calls and multiple result sets are supported. These result sets must not necessarily depend upon the Commarea. Also virtual tables are supported.

SQL-Syntax display in the Front end

Moving the mouse cursor over an SQL statement displays the syntax of the clause or the statement in form of a tool tip. This feature can be used to determine what clauses and statements are supported by the SQL-Engine and what their syntax is.

 

tcACCESS JDBC component (Option*)

The tcACCESS JDBC component can now run under the current Java Runtime Environment Version 6. This allows the usage of the new database access methods of standard JDBC 4.0 for user written applications and the most current J2EE Application Servers.

 

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 8.0. However, it is still possible to use an older mainframe component with the Version 8.0 clients or an older client with the Version 8.0 mainframe components.

 

* These are chargeable components and will be distributed to customers that have licensed the option and are under a current maintenance agreement. Custmers interested in the components can evaluate them free of charge for a period of 30 days. Licensing can be performed after the evaluation period.

 

TOP