VX/CDD - OpenVMS CDD

Overview

VX/CDD is a powerful data dictionary extraction and transformation tool that extracts DDL (Data Definition Language) from a VMS / OpenVMS CDD and imports it into a Sector7 Common Data Dictionary.

• Processes %INCLUDE, %FROM, and %CDD directives used in 3GLs and DEC products

• Converts CDD definitions into include files for multiple programming languages

• Maintains the CDD in standard DDL format, ensuring full OpenVMS compatibility

• Supports multiple languages and databases, including Pascal, Fortran, BASIC, C, C++, DECForms, and SQLMOD

VX/CDD Features

VX/CDD Language & Tool Support

VX/CDD is designed to seamlessly integrate with multiple programming languages and development tools.
‍

VX/CDD Workflow

VX/CDD automates the extraction, transformation, and integration of OpenVMS CDD data into modern development environments.

1️⃣ Extract DDL from OpenVMS CDD

VX/CDD retrieves structured Data Definition Language (DDL) from an OpenVMS CDD.

VX/CDD extracts DDL from OpenVMS CDD and processes it for target platforms.

2️⃣ Convert CDD Definitions to Include Files

VX/CDD transforms CDD field definitions into language-specific include files.
‍

FIELD EMPLOYEE_ID PIC 9(6).

FIELD EMPLOYEE_NAME PIC X(30).

FIELD SALARY PIC 9(7)V99.
        

typedef struct {

    int EMPLOYEE_ID;

    char EMPLOYEE_NAME[30];

    double SALARY;

} EMPLOYEE;
        

3️⃣ Process %INCLUDE, %FROM, and %CDD Directives

VX/CDD automatically resolves and expands embedded references in the source code.

Before Processing

%INCLUDE 'EMPLOYEE_DEF' %FROM CDD$DICT;

After Processing

TYPE
  EMPLOYEE_RECORD = RECORD
    EMPLOYEE_ID: INTEGER;
    EMPLOYEE_NAME: STRING(30);
    SALARY: REAL;
  END;

4️⃣ Database Migration Support

VX/CDD can convert Rdb SQLMOD definitions into PostgreSQL ECPG or Oracle Pro*C.
‍

DECLARE EMPLOYEE CURSOR FOR

SELECT EMPLOYEE_ID,
 EMPLOYEE_NAME, SALARY

FROM EMPLOYEES;
        

EXEC SQL DECLARE 
EMPLOYEE CURSOR FOR

SELECT EMPLOYEE_ID,
 EMPLOYEE_NAME, SALARY

FROM EMPLOYEES;
        

Why Use VX/CDD?

✅ Automates CDD Extraction & Processing

✅ Supports Multiple Languages & Databases

✅ Seamless Integration with VX/Pascal, VX/Fortran, VX/Basic, and VX/SQLMOD

✅ Future-Proofs OpenVMS CDD Definitions for Linux & Windows

VX/CDD ensures that legacy VMS CDD data remains accessible and maintainable, allowing seamless migration to modern platforms without losing functionality.