Transoft Developers

U/SQL 4.30 is now available.

The release notice, product documentation and other useful utilities can be found at  ftp://ftp2.transoft.com/pub/CDextras/USQL/README.htm.

New Features include:

Query Profiler

The Query Profiler can be used to monitor the performance of SQL queries. It has been designed as a diagnostic tool, providing detailed information about the timing and source of your SQL queries. One of the benefits of this is the ability to quickly identify the source of inefficient queries.

U/SQL HTTP Server

The U/SQL HTTP Server, introduced in engine revision 4.20.0100, extends the query facilities available in U/SQL to allow remote HTTP access to your U/SQL Server instance.

Accessed via your Internet browser, the HTTP Server is a quick and easy way to interrogate your UDD and data.

Windows VISTA

U/SQL Multi-Tier Server, U/SQL Single Tier Server and the U/SQL Client can all be installed on Microsoft Windows VISTA.

64 bit U/SQL Client

A 64 bit version of the U/SQL client DLL named tsodbc64.dll has been produced. This will enable people with 64 bit applications access data through U/SQL.

Extended SQL Support

U/SQL now handles SELECT and INSERT queries that use a sub-query with an ORDER BY clause.

Security in multi-company data.

A new command has been implemented:  EXCLUDE  allows users to be excluded from any access to the data if the Substitution is set to a specific value.

U/FOS

Allow access to remote UFOS databases using .unp files.

ACUCOBOL

U/SQL on Windows is now available for ACUCOBOL versions 7.3 and 8.0.