Transoft Developers

CIO 1.3 will be released in early January 2009. It will include the following features:

CIO Lock Server API for .NET

An API for the CIO Lock Server that can be used from any .NET language. We also produced a Java API for the CIO Lock Server in CIO 1.2.

CIO implements locking using a Lock Server rather than using RDBMS locking in order to fully emulate the locking functionality in the client application without requiring any application code changes or having a negative effect on RDBMS performance.

By providing an easy to use API to the CIO Lock Server, we enable you to develop applications in Java or .NET that access and update your RDBMS data concurrently with your legacy application.

CIO metadata creator options

The CIO metadata creator will be enhanced with new options to filter extra tables in FDs created by FlexGen and also to automatically convert the sqlname attribute of records and fields to lowercase.

The option to automatically create RDBMS tables and columns with lowercase table names and column names may be particularly interesting for PostgreSQL users.

Support for Transaction processing commands

CIO 1.3 will include  support for Transaction processing commands: START TRANSACTION, COMMIT TRANSACTION, ROLLBACK TRANSACTION.

New commands will be implemented in the CIO API and, where possible, the CIO I/O Intercept client library will intercept existing transaction processing commands in COBOL code.

Multi-company support

CIO 1.3 will provide a highly configurable method for implementing multi-company applications.

Typically a multi-company application will be able to access different sets of data depending on some variable such as the user id. With legacy COBOL data this may be implemented by accessing data files in different directories or by accessing data files with a specific naming convention.

CIO uses a simple client configuration file to provide this functionality when your data has been moved to an RDBMS without requiring any code changes.

Automated ETL program generation

CIO 1.3 will include a new development tool that will enable you to automatically generate a COBOL program that will extract the data from your COBOL files and write to the target RDBMS.

This program will provide an automated ETL process that has no intermediate flat files.

CIO Server Failover

CIO 1.3 will provide the ability to configure a failover CIO Server on the client side.

If, for any reason, the primary CIO Server fails, any subsequent client connections will be redirected to the failover CIO Server.

Create FDs and CIO metadata from existing RDBMS schema

CIO 1.3 will include a new utility which will read an existing RDBMS schema via a JDBC connection and will generate the FDs and CIO metadata that are required to access that data via CIO from a COBOL application.

This will be of interest to people who already have some data in an RDBMS and want to be able to integrate that data into their existing COBOL application.