U/SQL Client – Update Available

April 23, 2009 at 12:52 pm | In Transoft Products, USQL | Comments Off

After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail.

This problem affects the U/SQL client but is has been corrected and an update is available.

The problem started with .Net Framework 2.0 SP2 after a change was made in the way OdbcDataReader checks for Nulls in Sequential Access mode, calling SQLGetData with a BufferLength argument of 0 for variable width data types.  Certain ODBC drivers are not compatible with this pattern. For more information on this function and its arguments, see: SQLGetData Function http://msdn.microsoft.com/en-us/library/ms715441.aspx

Transoft Certifies U/SQL Adapters with Veryant’s isCOBOL Technology

April 21, 2009 at 3:16 pm | In Transoft Products, USQL | Comments Off

Transoft, the modernization experts, today announced it has certified its Transoft U/SQL Adapters for use with Veryant’s isCOBOL Application Platform Suite (APS). This qualification enables U/SQL users to deploy the same functionality when they move COBOL programs to isCOBOL APS, and provides enhanced capabilities for current isCOBOL platform users.

With over 60,000 users, Transoft U/SQL Adapters are widely used tools that provide relational database ODBC and JDBC access to non-relational data. The Adapters allow COBOL programs and Windows products to seamlessly access ISAM files as if they are a relational database. With Transoft U/SQL Adapters direct links from legacy data sources can be created into spreadsheets, word processing documents, report writers, business intelligence tools, and decision support products.

“Organizations with COBOL assets clearly benefit from choice in the market for application development and modernization”, explained Paul Bradbrook, managing director, Transoft. “By offering enterprises the benefits of both Veryant’s isCOBOL and Transoft U/SQL Adapters, we can help them strengthen their IT offerings and improve access to important legacy information, at very cost-effective levels.”

With an estimated 200 billion lines of COBOL in use today, modern COBOL alternatives like Veryant’s isCOBOL APS have become extremely popular. Veryant’s isCOBOL technology protects and extends valuable enterprise application assets by blending the optimized, business-oriented nature of COBOL with the openness, portability and power of the Java platform – without requiring businesses to retrain staff or rewrite code.

“By adding the value that Transoft U/SQL Adapters offer, Veryant is able to further help its customers gain even more advantage from their move to isCOBOL,” noted Alfredo Iglesias, vice president, Veryant. “With quick and reliable access to corporate data, Veryant customers can make better decisions.”

Release: DBPronto 1.4

April 21, 2009 at 12:13 pm | In DBPronto | Comments Off

DBPronto 1.4 is now available for download from the Transoft FTP site. This release is available on the following platforms:

  • Windows Server 2000, 2003, 2008, Windows XP, VISTA, 7
  • Linux PowerPC or Intel, 32 or 64 bit
  • HP-UX PA-RISC
  • Solaris SPARC

New features in the DBPronto 1.4 release include:

Block Read Mode in the DBPronto Server. This provides performance improvements where the client application is reading sequentially through the data.

PostgreSQL performance has been improved by modifying the query syntax to ensure the query plan is optimal.

Support for Micro Focus COBOL Filename Mapping.

If environment variables are set in one of the following formats, DBPronto will translate them at “open” time:

  • dd_FILENAME=DESTNAME
  • DD_FILENAME=DESTNAME
  • FILENAME=DESTNAME

Client Block Read

Block Read Mode can be used to improve performance by reducing the network traffic between the RDBMS and the DBPronto Server. Block Read Mode and Client Block Read Mode both improve performance in scenarios where the client application is reading a large number of records using READ NEXT or READ PREVIOUS.

If Block Read Mode is configured, Client Block Read Mode can also be used to reduce the network traffic between the DBPronto Server and the DBPronto client application.

The Metadata Creator will now ignore any records which have no indexes if command line option, x is specified.


Transoft Announces DBPronto

April 21, 2009 at 11:37 am | In DBPronto, Transoft Products | Comments Off

Rapidly replace legacy file systems with modern RDBMS

Transoft, an expert in innovative modernization software and service solutions, today announced the launch of DBPronto. Designed to work with legacy file handlers including COBOL, C-ISAM and Transoft U/FOS, DBPronto provides a rapid, easy and automated means of allowing legacy applications to use a modern relational database (RDBMS) such as Oracle, MySQL, PostgreSQL and Microsoft SQL Server – replacing older proprietary ISAM file handlers.

With Transoft DBPronto you can:

  • Improve data integrity and robustness
  • Implement database high availability solutions
  • Readily share data with other applications
  • Easily implement data warehousing and business intelligence solutions

DBPronto is based on Transoft CIO which was launched 6 months ago and is already being used successfully in a number of organizations. DBPronto extends the functionality to a wider range of legacy data structures, and provides a bridge between existing code and the new RDBMS.

“Transoft’s revolutionary new DBPronto product has enabled us to combine our existing Insurance Broker application with our new .NET based Life Insurance system without having to make extensive changes to either. This has opened up new markets for us with existing customers, as well as enabling us to provide a single integrated system.”
Alastair Bell, Managing Director, Relay Software

Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.