|
|
|
We have added the ability to handle data files that contain multiple data record formats (proprietary, non-relational) and map them into a relational representation. This gives you the ability to operate on this data from our SQL layer, opening up your data to the open standards world. This is a significant new feature that you will not find with any other database vendor.
Many users have taken advantage of the flexibility of c-treeACE’s ISAM or Low-Level record-oriented interface and have defined their own data record layouts. In many cases these layouts do not conform to the relational model required by a SQL engine. Proprietary data types, multiple record types based on a “record type” flag are common in many older c-treeACE based data files. This situation is most likely in prior c-treeACE applications that are later ported to c-treeACE SQL with minimal application changes.
With support for handling this type of data, c-treeACE can convert data formats at runtime and map non-relational data into a relational model “on-the-fly” to access this data via c-treeACE SQL.
Much as many existing c-treeACE applications have these types of mixed data records, many COBOL applications also utilize this type of multi-record type data and have the need to access it via SQL. Exporting and importing the data into an alternate SQL database is messy and time consuming. As such, we have implemented this multiple record format technology in our FairCom RTG COBOL Edition product, bringing advanced SQL access to your legacy COBOL data.
