THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Pro*Cobol Embedded Oracle to Cobol Embedded HiRDB Migration

Ispirer MnMTK database and application migration tool is a cost effective product that can cater unique business requirements. Our flexible tool is constantly evolving. We place our greatest stress to helping our customers to run a smooth database and application migration and accomplish a wide variety of tasks.

Pro*Cobol Embedded Oracle to Cobol Embedded HiRDB Migration

Conversion for Embedded SQL statements is based on initial implementation Oracle to HiRDB.

Conversion Features:

Connect Database/Transaction control Conversion

  • Connect statement conversion
  • Adding new fix byte Username and Password variables for connection since HiRDB does not support VARCHAR variables for connect
  • Adding "MOVE" logic for new declared variables

Cobol(Oracle):

  1. EXEC SQL
  2. CONNECT :ID22 IDENTIFIED BY :P22
  3. END-EXEC.

 

Cobol (HiRDB):

  1. WORKING-STORAGE SECTION.
  2. ** SQLWays Variable FOR Username/Password **
  3. 01 SQLWAYS-ID22 PIC X(08) DEFAULT SPACE.
  4. 01 SQLWAYS-P22 PIC X(30) DEFAULT SPACE.
  5. MOVE ID22-ARR TO SQLWAYS-ID22.
  6. MOVE P22-ARR TO SQLWAYS-P22.
  7.  
  8. EXEC SQL
  9. CONNECT USER :SQLWAYS-ID22 USING :SQLWAYS-P22
  10. END-EXEC.

 

 

Cursor Conversion

  • Select query in Cursor statement conversion based on the implementation of Oracle to HiRDB

Cobol(Oracle):

  1. EXEC SQL DECLARE EMPCURSOR CURSOR FOR
  2. SELECT T1.C2 INTO :VCHAR FROM T1, T2
  3. WHERE T1.C1=T2.C1(+)
  4. AND T2.C3(+)>0 AND T1.C4>0
  5. END-EXEC.

 

Cobol (HiRDB):

  1. EXEC SQL DECLARE EMPCURSOR CURSOR FOR
  2. SELECT T1.C2 INTO :VCHAR FROM T1 LEFT OUTER JOIN T2
  3. ON T1.C1 = T2.C1 AND T2.C3 > 0
  4. WHERE T1.C4 > 0
  5. END-EXEC.

 

 

DML Query Conversion

  • Select, Insert, Update, Delete statements conversion based on the implementation of Oracle to HiRDB

Cobol(Oracle):

  1. EXEC SQL
  2. UPDATE T1 SET C3=add_months(C1,C2)
  3. END-EXEC.

 

Cobol (HiRDB):

  1. EXEC SQL
  2. UPDATE T1 SET C3 = C1+C2 MONTH
  3. END-EXEC.

 

 

Procedure Call Conversion

  • Call statement in PL/SQL Block conversion
  • Removing Package name

Cobol(Oracle):

  1. EXEC SQL
  2. CALL myschema.mypkge.getsal(:increase)
  3. END-EXEC.
  4.  
  5. EXEC SQL EXECUTE
  6. BEGIN
  7. myschema.mypkge.raise_salary(:emp_id);
  8. END;
  9. END-EXEC.

 

Cobol (HiRDB):

  1. EXEC SQL
  2. CALL myschema.getsal(:increase)
  3. END-EXEC.
  4.  
  5. EXEC SQL
  6. CALL myschema.raise_salary(:emp_id)
  7. END-EXEC.

 

 

Declare Host Variables Conversion

  • Commenting SQLCA and SQLDCA variables
  • File’s includes conversion

Cobol(Oracle):

  1. EXEC SQL INCLUDE SQLCA END-EXEC.
  2. EXEC SQL INCLUDE D:\Test\Statements\incl_file.cob END-EXEC.

 

Cobol (HiRDB):

  1. ** EXEC SQL INCLUDE SQLCA END-EXEC.
  2. EXEC SQL COPY incl_file END-EXEC.

 

 

Extention Conversion

  • Converts .PCO extension to .ECB

Why Ispirer MnMTK?

Ispirer MnMTK automates the migration process of your Pro*Cobol Embedded Oracle applications to Cobol Embedded HiRDB. Moreover, with Ispirer MnMTK 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 instrument for this project type.


If you are interested in these services, please contact us for more information.

 
Testimonials
November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...

...

August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including embedded SQL migration in PowerBuilder)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to...

...

Case Studies
August 24, 2014PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was...

...

September 11, 2014Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, Visual Basic to C#, ASP to ASP.NET)

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.

...

Feedback

Now the developers know your tool works fine…
Thanks for your assistance and we take into account Ispirer for this migration or any other we have to do in the future.

Read more
Industry Events