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

Embedded SQL Statements in COBOL Applications

Embedded SQL Statements in COBOL

Embedded SQL statements consist of the following three elements:

  • Keyword pair:
     EXEC SQL
  • Statement string:
     Any valid SQL statement
  • Statement terminator:
     END-EXEC.

For example,

  1. EXEC SQL SELECT col INTO :hostvar FROM TABLE END-EXEC.

Why Ispirer MnMTK?

Ispirer MnMTK helps you to automatically perform comprehensive assessment and migration of embedded SQL statements in COBOL applications. With Ispirer MnMTK there is no need extracting SQL statements from application code and convert them separately. The tool completes the whole migration process internally.

Conversion features

SQLWays converts SQL statements to conform to the syntax of target database.

For example,

Source Informix database:

  1. EXEC SQL
  2. SELECT cur_date
  3. FROM val_date
  4. WHERE cur_date < CURRENT
  5. END-EXEC.

Target MSSQLServer database:

  1. EXEC SQL
  2. SELECT cur_date
  3. FROM val_date
  4. WHERE cur_date < GetDate()
  5. END-EXEC.

SQLWays is capable of supporting the various types of source and target databases in the COBOL applications.


How to convert?

Please complete the questionnaire to initiate collaboration discussions for your project or get some rough estimation:

Please take a look at the related article: Embedded SQL and Database Access API Migration

Ispirer MnMTK automates the entire migration of embedded SQL in COBOL applications. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes Ispirer MnMTK even more powerful instrument for such migration type.


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

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


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, VB 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

I have been able to install the tool, and I must say that it has been one of the best I have found on the Internet. For the moment I’ve learned to manage the tool well.

Read more
Industry Events