Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

COBOL to Oracle PL/SQL Conversion

Oracle Logo

Ispirer Migration and Modernization Toolkit performs COBOL to Oracle PL/SQL conversion of any complexity.


Why Ispirer MnMTK

Ispirer MnMTK automates the entire migration process COBOL to Oracle PL/SQL conversion. Moreover, choosing Ispirer MnMTK to convert COBOL you eliminate most of associated risks and considerably reduce internal efforts. All these benefits are available at very reasonable and competitive costs, which makes Ispirer MnMTK even more attractive conversion tool for this project type.

Our main benefits:

  • High quality and experiences technical support: our technical team has a tremendous experience in migration projects of different levels of complexity.
  • Customer-oriented approach and Fast Customization: we personalize our migration tool in such a way that a customized version can fully satisfy our client’s business needs, custom conversions and optimizations are made within 1-2 business days;
  • Pre-Sales Engagement: we demonstrate a full conversion during the evaluation before you make a decision.
  • Flexible pricing: we can offer you a wide range of options, among which you will definitely find the one which suits you;
  • Optimized Conversion: after the conversion you get an intelligent and maintainable code, without using any Ispirer's middleware.

This demo shows how Ispirer MnMTK can convert COBOL applications to Oracle PL/SQL:


Assessment and Purchase Process

The assessment of your migration project could definitely help to weigh up efforts and the approximate cost of your migration. In order to facilitate the process, you're welcome to send us the details about your project while requesting for the quote:


Live Presentation

Ispirer Migration Solution

COBOL to Oracle PL/SQL Conversion

Request

Request a Quote

Ispirer Migration Solution

COBOL to Oracle PL/SQL Conversion

Service Toolkit

Conversion Features


COBOL Program Structure

  1. IDENTIFICATION DIVISION.
  2. PROGRAM-ID. DemoId.
  3. ENVIRONMENT DIVISION.
  4. DATA DIVISION.
  5. PROCEDURE DIVISION.
  6. FIRST-PARAGRAPH.
  7. DISPLAY "First DEMO".


There are the four divisions:

  • IDENTIFICATION DIVISION: This is where you must enter the program name.
  • ENVIRONMENT DIVISION: This is where you define the files the program needs.
  • DATA DIVISION: This is where you declare variables, records, files etc.
  • PROCEDURE DIVISION: This is where you write the program. In the sample above this is all in one paragraph. A paragraph is a series of statements named by a label. There is no specific mark to the end of a paragraph.


Conversion features

  • Migrates database of COBOL’s application to Oracle database
  • Convert COBOL’s programs to Oracle packages
  • Convert PROCEDURE DIVISION to Oracle package specification
    1. CREATE OR REPLACE PACKAGE DemoId
    2. AS
    3. PROCEDURE DemoId;
    4. END;
    5. /
    6. CREATE OR REPLACE PACKAGE BODY DemoId
    7. AS
    8. PROCEDURE DemoId
    9. AS
    10. BEGIN
    11. DBMS_OUTPUT.PUT_LINE("First DEMO");
    12. END;
    13. END DemoId;
    14. /

  • Convert WORKING-STORAGE section with declaration variables and records to Oracle DECLARE statement
    1. WORKING-STORAGE SECTION.
    2. 01 MY_STRING_1 PIC X(20).
    3. 01 MY_STRING_2 PIC X(30).
    4. 01 MY_NUMBER PIC 9(2) VALUE 1.

    To:

    1. DECLARE
    2. MY_STRING_1 VARCHAR(20);
    3. MY_STRING_2 VARCHAR(20);
    4. MY_NUMBER NUMBER := 1;

  • Convert COBOL records to Oracle records
    1. 01 MY_DATA_RECORD.
    2. 03 MY_NAME PIC X(20).
    3. 03 MY_ADDRESS PIC X(40).
    4. 03 MY_ID PIC 9(2).

    To:

    1. DECLARE
    2. TYPE MY_DATA_RECORD IS RECORD (
    3. MY_NAME VARCHAR(20),
    4. MY_ADDRESS VARCHAR(40),
    5. MY_ID NUMBER);

  • Convert COBOL MOVE TO/COMPUTE statements to Oracle assignment statements
    1. MOVE 5 TO MY_NUMBER.

    To:

    1. MY_NUMBER:=5;

  • Convert COBOL sections (group of paragraphs or statements) to Oracle procedures. The SECTION could be called using PERFORM statement. PERFORM is converted to call of Oracle stored procedure.
  • Convert COBOL control structures to Oracle control statements
    1. IF condition
    2. COBOL statements
    3. ELSE
    4. COBOL statements
    5. END IF

    To:

    1. IF condition
    2. Oracle statements
    3. ELSE
    4. Oracle statements
    5. END IF;
    And
    1. PERFORM UNTIL
    2. COBOL statements
    3. END-PERFORM

    To:

    1. WHILE condition LOOP
    2. loop_body
    3. END LOOP;

  • Converts Screen output (DISPLAY statement) to DBMS_OUTPUT.PUT_LINE
  • Converts EXEC SQL/ END-EXEC(select, insert, update, delete, CURSOR statements) statements to Oracle SQL statements (SELECT, INSERT, UPDATE, DELETE, CURSOR statements)
    1. EXEC SQL
    2. SELECT cur_date
    3. FROM val_date
    4. WHERE cur_date < CURRENT
    5. END-EXEC.

    To:

    1. SELECT cur_date
    2. FROM val_date
    3. WHERE cur_date < SYSTIMESTAMP;

  • Automatically converts SQL statements in Embedded SQL (EXEC SQL/END-EXEC.) to conform to Oracle PL/SQL

You are welcome to contact us for more information.

 
Testimonials
December 3, 2012Epicor Software Corporation, United States
Progress 4GL to C# .Net Migration

"Epicor has engaged with the Ispirer team to create and refine prototype techniques for migrating certain parts of the Epicor Progress ABL code to well...

...

Case Studies
May 26, 2014COBOL to .NET Conversion, United States

Our client was a major player in market-driven innovation and science. For more than two hundred years, it has been presenting world-class science and engineering to the global marketplace...

...

September 12, 2014Delphi to C# .NET, United States

Our client was a U.S.-based health insurance company providing care services since six decades through its extensive network of hospitals and other institutions.

...

Feedback

I just want to touch base with you to let you know that the tool is doing great work so far.

Read more
Industry Events