BOI Software Entwicklung und Vertrieb GmbH

Phone: +43 (0) 732 / 736423 - 0

Spazgasse 4

Email: office@boi.at

4040 Linz, Austria

www.boi.at

The new TABEX/4 Release 4.1.0

The new TABEX/4 Release 4.1.0 will be provided for download on our website October 10th 2010 ...

New enhancements in Release 4.1.0:

  • new TABEX/4 program load library for z/OS
  • MS EXCEL Import/Export
  • SSO-Login
  • Extended PDF Print
  • z/OS Installation Dialog
  • JAVA Interface
  • Selection List
  • Linux 64-bit & Shared Memory
  • New Views
  • SQL Tables
  • Summary Database
  • Utilities Online
  • Online Help

General informations about the new release:

The new TABEX4 Release 4.1.0 will be available for download at our website on 2010/10/10. The following products are available:

   1. TABEX/4 Basic System and Table Maintenance System
   2. TABEX/4 Basic System with DB2-ODBC Access and Table Maintenance System
   3. TABEX/4 for Windows C/S System

Please request your login for the download area by e-mail.

Detailled description of the enhancements:

New TABEX/4 program load library for z/OS

From this release on, the access routines are separated from the table maintenance system.

Because we want to save our customers the expensive testing of application programs, we decided to provide a separate program load library (called APPCALL), containing the programs for the table access functions only. It is planned to leave the APPCALL library unchanged for future releases of TABEX/4.

MS EXCEL Import/Export

Many TABEX/4 users use the benefits of MS EXCEL for generating diagrams, statistical analysis, presentations and reports. There is a great demand to use this program also for data stored in TABEX or DB2 tables. With this new release, table data from data bases can be exported to MS EXCEL and imported from MS EXCEL with the TABEX/4 Table Manager.

The export of tables or of the active table maintenance area into CSV format enables the transfer of table data from data bases into programs such as MS EXCEL.

Data formated as CSV (e.g. MS EXCEL data saved as CSV file) can be imported into a TABEX table. The data must meet the following requirements for a successful import: The CSV file must have the same table structure (table columns) as the table where the data shall be imported. The CSV formatted data can either replace a whole table or add new rows to the existing table. When the table is saved, all imported data are checked (using check tables and the referential integrity rules.

To learn more about how to work with these functions please refer to section "expert advice" in this newsletter.

SSO Login

The new release includes interfaces for integrating the TABEX application into existing Single Sign On solutions. If SSO login is activated and configured for the user, the user only needs to log in to the operating system. There is no need to extra log in to TABEX, the typing of user name and password is no longer necessary.
You are able to define a customer-specific filter which provides the TABEX SSO interface with all needed registration information.

PDF Print Enhancements

Table contents can be printed in PDF format during an online session:

  • whole tables
  • parts of tables
  • selected table rows or table fields.

The selection criteria are printed at the front page of the PDF document.

z/OS Installation Dialog

The new installation dialog for z/OS adapts the installation procedures and examples in the SAMPLE library according to the user input during the installation process. All installation steps and sample calls of TABEX applications can now be executed without any further adaptations by the administrator.

JAVA-Schnittstelle

The JAVA interface has been extended and the following methods were added:

  • insertRow (add table row)
  • saveToDB (save modified data to database)
  • deleteRow (delete table row)
  • deleteRows (delete several rows that match a search criterion).

Selection List

As announced in our last newsletter, you can now replace the lookup panel (hot key F2) by the new selection list. The lookup panel showed the possible values of a field. Now the set of available values can be displayed in a popup window as is typical for Windows applications. This allows the selection of a value out of a collection of possible values. If a value has been entered in the field, the cursor is automatically placed at this value in the popup menu.

Linux 64-bit Version & Shared Memory Tables

Our customers already use the TABEX/4 Linux 64-bit version. The platform independent kernel of TABEX - the so-called virtual machine - has been ported to Linux 64-bit. All platform independent parts of the software run on the virtual machine so these parts remained unchanged.

Now the feature of the high performance memory tables in shared memory can be used for a high amount of tables, and the limit of the 32-bit addressing was eliminated.

New Views

By using a SELECT statement TABEX table data can be retrieved or saved as views or new tables. The syntax corresponds to the SQL-standard and has some TABEX specific enhancements.

Example combining the TABEX tables PRODUCT, PRODNAME und PRODGRP:

SELECT PRODNR,PRODNAME.TEXT,PRODGRP.TEXT,PRODPRICE FROM PRODUCT,PRODNAME,PRODGRP,WHERE PRODUCT.PRODNR = PRODNAME.ID AND PRODUCT.PRODGRP = PRODGRP.ID

SQL Tables

Tables with SQL connection (type SQLT) can be generated using the TABEX/4 Table Manager. Functions for displaying and changing the definitions of these tables are available.

AI Tables

With the TABEX/4 Table Manager alternate index tables (AI tables) can be defined and the directory of all AI tables available in the TABEX database can be displayed.

Summary Database

You can combine several databases to one single logical database. Two types of summary databases are available:

  • Standard Summary Database
  • Chain Summary Database

In a Standard Summary Database, entries of the different databases are interpreted as if they were in one single database. This enables the user to put together several application databases from different projects into one single logical database.

In a Chain Summary Database, the order of the physical databases determines the entries in the Summary Database Index. The Summary Database always uses the table of the first physical database, and ignores all tables with the same name which might be in the following databases. This enables users to put together tables of several test environments.

Utilities Online

Utility procedures can now be configured as menu items using the TABEX/4 Table Manager. (Formerly they were only executed immediately in the online session.) In case of successful completion a system message is displayed. In case of error the utility protocol is displayed.

Online Help

The help system has been redesigned. Now we maintain the help contents using a content management system. The help system is exported into static HTML format so you do not need to install the content management.

The file path can be configured to integrate the help system into your intranet environment.

Date: 08.10.2010

Migration Packages

BOI GmbH offers migration packages for the table management systems SPITAB, TABSYS and VTAS.

 

» Migrations Packages

Success Stories

AirPlus has been using TABEX for 20 years.

Now TABEX/4 JAVA APPLICATION ENGINE has additionally been launched for audit-proof logging of the business processes by Java applications.

 

» read this success story

» more success stories