[Info-vax] RDB Question

[Denys Beauchemin]

For the last several years, we at Sector7.com have been developing and enhancing a product called SQLCC  (vx/sqlmod) that converts Rdb SQLMOD files to access Oracle 11g and more recently 12c.  The generated code creates modules that have exactly the same API for the application code and allows the application to remain on VMS and access Oracle on another server if desired.

More recently, we have extended the supported target SQL databases to now include Postgres V11.  The SQLCC tool runs on Linux to do the code conversion and the generated .pgc files can then be copied to VMS where they are pre-processed and then compiled with the VMS/C compiler and linked to the existing application.  Essentially these new files simply replace the existing SQLMODs in a plug’n’play fashion and allows the application running on VMS to access Postgres on a separate server.  This removes the RDBMS server load from the VMS server and reduces dramatically the cost of RDBMS licenses as Postgres is open source.

The conversion is totally transparent to the application, the users and so on.  The application remains on VMS; the data is on a Postgres server and now easily accessible from any other platform with tools, utilities, decision graphics, analytics apps and so on that can talk to Postgres.  And no RDBMS licensing fees.

We’ve been adding several neat features designed to enhance development and testing with Postgres such as semantics checking and automatic driver code generation with test script recording and playback.