BOI Software Entwicklung und Vertrieb GmbH

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

Spazgasse 4


4040 Linz, Austria


TABEX/4 functions for data transfer, copying and moving, importing and exporting and other tasks permit the unlimited distribution of table data in heterogeneous IT environments. Thus table data are available system wide for all IT procedures and for any other application.

Copying and Moving of Tables

Tables can be copied and moved within the database or across databases.

Migration of Table Data between Relational Databases

You have tables in relational databases and require them in another relational database on a different operating system?
You want to migrate table data of one database to a different database with different structure?

TABEX/4 offers you the tool to transport data between different relational databases. For example, you can maintain data stored in Oracle in DB2 or transport data from Informix to DB2.

Figure: Example for a migration from Informix to DB2

Using TABEX/4 utilities TABN02 (command SQLTAB) / TABN05, data of the source RDB (in the example: Informix) are buffered in a TABEX DB (in the example: TABEX_DBi). In most cases, datatype conversions are needed. Therefore, an application program must be implemented to adapt the datatypes and save the table in another TABEX DB (in the example TABEX_DBd). Using utility command SQLUPD, this TABEX_DBd is transferred to the target database (in the example: DB2). If the corresponding table does not yet exist in DB2, it can be created in the target database using utility TABN06.

Please contact our support, if you want to learn more about this feature.


Unlimited Data Transfer

By using TABEX/4 utility functions, data may be transferred between different data sources (e.g., TABEX tables, sequential files, tables from relational data bases such as DB2, Oracle, MS SQL Server, Informix, PostgreSQL, Mysql, ...). All combinations of source and destination are supported.

Import/Export of Tables

Many TABEX/4 customers use MS EXCEL and other programs for diagram generation, statistical analysis, presentations and reports, so there is a need to manage table data outside of databases.

With TABEX/4 this can be easily done.

The export of tables or the active table maintenance area enables the transfer of table data from databases into other applications, e.g. MS EXCEL, in order to edit them onward.

It is also possible to import changed data from MS EXCEL or other programs to TABEX/4 (again). The imported data can either replace the whole table or they can be added to the existing data. When the table is saved the imported data will be checked (check tables, RI checks, etc.).


Table data and table selections can be exported as TEXT or PDF documents.

TABEX/4 Mail

The TABEX/4 Mail Program Interface enables sending of generated PDF or CSV files, logs of batch programs or any other data attached to e-mails.

Replication of Data

Automatic replication synchronizes databases and data spaces across platforms.

Advantages of the automatic replication:

  • central administration of data for different project areas
  • increased availability of data
  • offline access to local replicates
  • higher performance of read access (shorter response time)


Changes in ESA data spaces, efficient migration and a new success story: Learn more in our newsletter!


Migration Packages

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


» Migration Packages

Success Stories

GDIS and BOI: Carrying on the Success

With TABEX4 JTC, GDIS has introduced the world's fastest Java interface for table access on customer and control data. Learn the details in our new Success Story.


» read this Success Story

» read more Success Stories