Transoft Developers

DBPronto v2.30 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
• IBM AIX 64 bit
• Solaris SPARC

A large number of features are included in this release and other product releases since v2.0.

Additional Functionality

• Support for Fujitsu COBOL inthe DBPronto I/O Intercept libraries.
• Transaction processing is now supported in the C-ISAM/D-ISAM client libraries.
• Add support for time and timestamp field types
• Allow definition of return value to be used when reading sanitized date and time fields
• Enable configuration of C-ISAM MAX_REC_LEN value.
• It is now possible to load changes to the metadata or load new metadata without stopping and starting the DBPronto Server. A ‘Refresh Metadata’ button has been added to the DBPronto Administrator.
• Use KEEPALIVE to ensure the DBPronto Server is notified when client processes disconnect. This ensures resources such as locks can be released.
• Improvements in the .NET API to the Lock Server
• If the DBPronto Server connection to the RDBMS is broken, allow configuration for re-connect.

Performance Improvements

• When using DBPronto I/O intercept client libraries and passing file I-O to the native COBOL file handler
• Use stored procedures for READ operations when keys are composed of multiple fields; also for DBAM READ and WRITE.
• Allow the use of joined sub-queries for DBAM
• The DBPronto Server and Client can now be configured to communicate via named pipes rather than sockets.

DBPronto Pre-Processor and DBP API client library

• Provide emulation of RM-COBOL C$RERR
• Provide emulation of RM-COBOL specific START FIRST/LAST syntax.
• Ensure the pre-processor handles  RM-COBOL clauses: SELECT NOT OPTIONAL, NOT INVALID, NOT AT END
• Implement a pre-processor to convert ACUCOBOL Transaction statements to DBP API calls.

Metadata Creation and Management

• Allow definition of a condition for a sub-table to avoid empty rows in the sub-table.
• Create all definitions for U/FOS DBAM files
• The metadata creator has been enhanced to allow definition of the  record prefix, a file containing ‘replace’ words, and an option specifying the redefine to use.

A new facility is now available which may be useful for people who already have some data in an RDBMS and would like to access the data via DBPronto from a legacy application.

The DBPronto Schema Converter converts an SQL schema into a COBOL data format which can be used by COBOL programs to access the database, and also into an XML format which can be accepted by the DBPronto Server to control access the RDBMS.

The converter accepts a list of SQL table names; for each table it uses JDBC metadata commands to read the table metadata, which is then processed to produce SELECT and FD statements for use by a COBOL program, and also an XML file for use by the DBPronto Server.

The schema converter will attempt to produce output which will be acceptable to both a COBOL compiler and also the DBPronto server. However, this is not a process that can be guaranteed to succeed; for example, an SQL field name might clash with a reserved word for a particular compiler, or a field size might not be acceptable. The schema converter provides some options that can help in this case, but it is still possible that manual editing of the output files will be needed.

Click here to download the DBPronto Schema Converter.

DBPronto 2.0 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 and Intel

The major features of this release are the addition of support for U/FOS DBAM (Data General INFOS) file access as well as support for C-ISAM/D-ISAM file access.

Applications that previously accessed U/FOS or C-ISAM data can now access the data migrated to RDBMS tables with no changes to existing source code.

The new features in DBPronto 2.0 include:

Support for DB2. The databases that can be accessed by the DBPronto Server are SQL Server, Oracle, MySQL, PostgreSQL, Sybase, and now, DB2.

Support for C-ISAM/D-ISAM file access. Applications that access C-ISAM/D-ISAM data can now access RDBMS data with no code changes, it is not even necessary to re-compile.

Support for U/FOS DBAM file access. U/FOS, originating from Data General INFOS,  is a complex hierarchical database management system. Applications that use U/FOS can now access RDBMS tables instead without making any changes to the application code. DBPronto fully implements the functionality provided by the U/FOS file access commands.

DBWHERE performance feature. DBPronto has been enhanced to enable application programs to specify a partial WHERE expression that will be included in the query executed for a subsequent READ NEXT/READ PREVIOUS operation.

Flexible filenames. The VARFN feature has been extended so that filenames can be specified using any regular expression.

CBL_CHECK_FILE_EXIST. The DBPronto EXTFH client library has been enhanced to provide support for the CBL_CHECK_FILE_EXIST runtime routine.

DBP_GET_USER_INFO. The DBPronto client API library has been extended to provide this new command that returns information related to the session ID, this can be used to identify the owners of locked rows for example.

CHANNEL_LOCKING_MODE. This is a new DBPronto Server configuration option that enables definition of the way in which locking works when a file is accessed by the same client on multiple channels.

For more information, please download the DBPronto 2.0 Release Notice