Transoft Developers

New features in the CIO 1.3 release include:

• Optional mapping to SQL Date types : A numeric or display COBOL data field can be mapped to an SQL date type.
• Support for the Sybase Advantage Database Server
• Support for Transaction processing commands :  COMMIT TRANSACTION, ROLLBACK TRANSACTION.
• COBOL Relative files can now be mapped to an RDBMS table using CIO.
• CIO Lock Server API for .NET : An API for the CIO Lock Server that can be used from any .NET language.
• CIO Server Failover : If, for any reason, the primary CIO Server fails, any subsequent client connections can be redirected to the failover CIO Server.
• Multi-company support : CIO uses a simple client configuration file to provide multi-company support after  data has been moved to an RDBMS without requiring any code changes.
• Automated ETL program generation : automatically generate a COBOL program that will extract the data from your COBOL files and write to the target RDBMS.
• Data cleansing and mapping : CIO can be configured to handle nulls in fields where printable ASCII characters are expected, uninitialized binary fields, spaces in numeric fields, invalid date values.
• Index Access : CIO handles HIGH-VALUES in key fields. CIO uses Primary Key specification when creating the RDBMS data structures.