Description:
VX/SQLMOD is a powerful migration tool that converts Rdb SQLMOD procedures into embedded SQL in C using Oracle Pro*C or Postgres ECPG. This transformation allows existing VMS/OpenVMS applications to access Postgres or Oracle databases on Linux while maintaining the original business logic and structure. VX/SQLMOD supports both on-premises and cloud-based database migrations, providing cost savings and performance enhancements while ensuring compatibility with future database technologies.
Why Migrate Rdb SQLMOD to Oracle or Postgres?
Eliminate Dependence on Rdb and Reduce Costs
• Postgres offers up to 80% cost savings for enterprises transitioning away from proprietary database solutions.
• By migrating Rdb to Oracle or Postgres, businesses can modernize their infrastructure while retaining full application functionality.
Seamless Integration with Existing VMS/OpenVMS Applications
• Applications using Rdb SQLMOD procedures can continue to run on VMS/OpenVMS or migrate to Linux without modifications.
• The converted SQLMOD procedures interact natively with Oracle and Postgres databases, enabling organizations to transition smoothly.
VX/SQLMOD Migration Process
Step-by-Step Conversion Workflow
1. Reads SQLMOD source code from Rdb applications.
2. Generates Pro*C or ECPG embedded SQL modules, maintaining functional equivalence.
3. Extracts and converts data type definitions from the VMS CDD libraries into equivalent C header files.
4. Modifies SQL calls to conform to ANSI SQL standards, ensuring compatibility with Oracle and Postgres.
5. Produces compiled C modules that integrate seamlessly with Fortran, COBOL, C, and C++.
6. Links the newly generated code with the original application, allowing for immediate execution.
