Transoft Developers

DBPronto v3.50

DBPronto v3.50 is now available for download from our FTP site.

This version includes improved support for the new alternative query mechanism. This new functionality originally introduced in version 3.40 provides application developers with a means of defining alternative SQL queries to override the default queries generated by the DBPronto server.

Alternative queries can be more efficient and potentially faster than those generated by DBPronto since they can take advantage of the application developers in-depth knowledge of their system.

Alternative queries can include joins that enable multiple tables to be read using a single query. When using such joins care must be taken, as if too complex they may have a detrimental affect on performance.

The alternative query mechanism requires only minimal program changes since the queries and how they relate to I/O statements are defined in metadata files. The mechanism currently only supports the READ and REWRITE statements on COBOL index files.

Please refer to the DBPronto documentation for more information.

Have fun.