Automated Application Conversion

Do you need to convert your Informix 4GL application to Microsoft T-SQL? In this case, Ispirer products will be the perfect solution for your project!
Human-written code in each project has its own specifics. It may seem difficult to obtain a high level of automated conversion. With Ispirer it will be a smooth transition. The main advantage of Ispirer Toolkit is the personalization for your conversion project. As a result, you will replace the old technology with all its downsides. The outcome will be a new application without any middleware used afterwards.

How it Works

Ispirer Toolkit

Automated conversion of Informix 4GL to Microsoft T-SQL with the help of our tool makes it possible to significantly reduce the time and expenses as compared to manual rewriting of the application. The following approach allows to ensure high quality of automated conversion:

1. Preliminary Stage

The stage is carried out to determine the current conversion level of Ispirer Toolkit. The level of conversion depends on the complexity of the source code and the requirements for the target application. You can independently perform the analysis of the source code of your Informix 4GL application, as well as try to convert it to Microsoft T-SQL using the demo license. Besides, our experts can perform the source code analysis and provide you with examples of its conversion.
If your application is quite specific and large, we recommend to perform PoC to determine the maximum level of automated conversion of your project.
As a result, we will find out whether the customization is required or you can directly proceed to the conversion.

2. Ispirer Toolkit Customization Stage

If this stage is necessary, we will perform the customization to thoroughly prepare the toolkit for the conversion according to your project requirements. We will take a part of a representative code that amounts ussually to ~100,000 lines. The Ispirer technical team will add all the required conversion rules into the tool to achieve the highest possible level of automation or even to get a compilable result. As a delivery, we will provide conversion results of the scope of this customization. The customer will get a tailored and updated tool according to his specific project needs.

3. Use of Ispirer Toolkit

At this stage, you perform the conversion yourself. As to pricing, we apply project-based licensing. Prices depend on its scope and duration. The license includes support as well. If necessary, the conversion may be further improved even at this stage. As a result, customization requests, each of which is processed within 1-3 business days, are added to the license. Our experts will recommend the optimal number of requests considering the complexity and requirements of your project.

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL
Free Demo License

Try Now

Ispirer Migration and Modernization Service (Ispirer Service)

Our experienced team can provide you with a turnkey migration service and convert your entire Informix 4GL application to Microsoft T-SQL, delivering you a ready-to-use application in due time. Our responsibilities include not only professional analysis, assessment, performance and testing of your migration, but also services such as adding new or changing existing functionality of the application.

If you want to get an intermediate result of the converted Informix 4GL code in the Microsoft T-SQL language, the Ispirer team will be glad to provide you with a basic migration service. As a result, you will get code that is optimized to the compilable level. Further, you will have to independently bring the application to a fully functional state in accordance with your requirements.

You are free to choose a preferred option. Nevertheless, we can provide an estimate of both the Tool and the Service, and give professional advice.

Conversion Overview

Converts Informix 4GL functions (*.4gl) to T-SQL functions/procedures (*.sql)

Informix 4GLMicrosoft SQL Server T-SQL

function sample_func(s_char)
#-------------------#
define
    s_char          char(100),
    i               smallint,
    j               smallint,
    r_char          char(100)
 
    let r_char = " "
 
    for i = 1 to 100
        if (s_char[i,i] = " ") then
            continue for
        else
            let r_char = s_char[i,100]
            exit for
        end if
    end for
 
    return r_char
 
end function

FUNCTION  sample_func(@s_char CHAR(2000)) 
---------------------#
RETURNS CHAR(2000)
BEGIN
   DECLARE @i  INT = 0
   DECLARE @j  INT = 0
   DECLARE @r_char  CHAR(100) = ' '
   DECLARE @SWR_i INT
   SET @r_char = SUBSTRB(' ',1,100)
   SET @SWR_i = 1
   while (@SWR_i <= 100)
   begin
      SET @i = @SWR_i
      if(SUBSTRB(@s_char,@i,1))
         continue
   else
      begin
         SET @r_char = SUBSTRB(SUBSTRB(@s_char,@i,101 -@i),1,100)
         BREAK
      end
      SET @SWR_i = @SWR_i+1
   end
   return @r_char
end

Converts comments:

Informix 4GLMicrosoft SQL Server T-SQL

 
  #Single line comments
 
  {
  Multiline comments
  }

 
  --Single line comments
 
  /*
  Multiline comments
  */

Convert data types

Informix 4GL type	Microsoft T-SQL data type
char(length)	CHAR(length)
smallint	INT
integer	INT
date	DATETIME
decimal(n,m)	DECIMAL(n,m)

Converts records to table type variables

Informix 4GLMicrosoft SQL Server T-SQL

 
define c0 record like ctl_f0.*

 
Declare @c0 Table (ctl_f0_id INT, ctl_f0_name VARCHAR(100), ctl_f0_description VARCHAR(1000))

Converts built-in functions, expressions and predicates

	Informix 4GL type	Microsoft T-SQL data type
Ascii function	let a = ascii 223	SET a = CHAR(223)
Clipped function	let a = b clipped	SET a = RTRIM(b)
Date function	let a = date(b)	SET a = CONVERT(DATETIME, b)
Day function	let a = day(b)	SET a = DATEPART(DAY, b)
Mdy function	let a = mdy(b,c,d)	SET a = CONVERT(DATETIME,STR(b) + '-' + STR(c) + '-' + STR(d))
Month function	let a = month(b)	SET a = month(b)
Upshift function	let a = upshift(b)	SET a = UPPER(b)
Using function	let a = b using "######&"	SET a = STR(b,[’9999990’])
Year function	let a = year(b)	SET a = year(b)
Concat expression	let a = b, “cd”,d	SET a = b + [“cd”] + d
Mod expression	let a = b mod 2	SET a = b%2
Substring expression	let a = b[2,2]	SET a = substr(b,2,1)
True/False expression	let a = true let a = false	SET a = true SET a = false
Matches predicate	if (n not matches "[0123456789]") then	if (not regexp_like(n,'[0123456789]')) then

Converts statements of business logic

For example,

For range loop

Informix 4GLMicrosoft SQL Server T-SQL

for i = 1 to 10
…
end for

   SET @i = 1
   while (@i <= 10)
   begin
      …
      SET @i = @i+1
   end

Case statement

Informix 4GLMicrosoft SQL Server T-SQL

case a
  when 1 
  …
  when 2 
  …
  otherwise
  …
end case

IF @a = 1 
      …
ELSE IF @a = 2
      … 
ELSE 
      … 
END

Declare cursor

Informix 4GLMicrosoft SQL Server T-SQL

declare cur_n0 cursor for
  select n0_ch from nkin_a
      where (n0_kau_no = s_kau_no)
      and   (n0_cd = s_cd)

DECLARE CUR_N0 cursor FOR select n0_ch from nkin_a
     where (n0_kau_no = s_kau_no)
     and   (n0_cd = s_cd)

Informix Database Migration

Along with converting Informix 4GL to SQL Server Transact-SQL, Ispirer solutions can automate the entire migration of your Informix database objects, including tables, data, as well as SQL business logic, to any other technology. As a result, you get a fully functioning database system. Choosing Ispirer's comprehensive migration solution, you will be able to eliminate most of associated risks and considerably reduce internal efforts. Click here to learn more about Informix migration.

Get a Project Estimate

Ispirer Toolkit

Reach the maximum level of automation and quality of your conversion with the help of Ispirer Toolkit! Based on your requirements, the Ispirer team will process all extension requests for your Informix 4GL to Microsoft T-SQL conversion project. We offer several types of Ispirer Toolkit licenses, among which you will find the one that is suitable for you. Each conversion project is considered and discussed separately, prices depend on its scope, duration and complexity.

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL

Get an Estimate

Ispirer Service

If you don't want to involve your own resources to move the Informix 4GL application to Microsoft T-SQL, get Ispirer Migration and Modernization Service and we will deliver you an operational and high-quality end-result on time and at a reasonable price. Apart from professional Analysis, Evaluation, Performance and Testing of your migration, we also provide such services as Code Refactoring, Changing Functionality, and Adding Extra Functionality. Each conversion project is reviewed and discussed separately and the final price is a subject to negotiation.

Ispirer Migration Service
Informix 4GL to Microsoft T-SQL

Get an Estimate

Benefits You Get

Conversion Automation

Automation will definitely facilitate the conversion, the manual work after the process will be significantly reduced.

Flexible Pricing

You pay for only what you need: pricing depends on the scope, complexity and duration of your conversion project.

Use of Modern Technology

You get an intelligent and maintainable code, and immediately start enjoying the benefits of new technologies.

What Our Customers Say

Tim Sexton | Project Lead

"Beckman Coulter provided as much of the information as we could but there was a lot of functionality that we did not know. This is where Ispirer talents became apparent as they forensically reengineered functionality."

George Cavanaugh | IT Manager

"We are now successfully running live on the new system, with the updated PB apps. I want to express my thanks to Ispirer team. You made this project a success!!! I was happy to work with you and would highly recommend Ispirer!"

Vladimir Labar | Software Developer

"Because of Ispirer and MnMTK, our team was able to devote its time to build the infrastructure for new Java programs instead of spending time on converting code. The produced Java code met all our maintainability, readability and performance requirements."

Yoshiro Suyama | Senior Specialist

"This approach was very successful avoiding any confusion at the first stage, and achieved high conversion rate in the end. The project was completed successfully, they say they couldn't make it without MnMTK 2017 and excellent extension support from lspirer."

Eric Kalabacos | Vice President

"At the onset of the engagement the Ispirer MnMTK was expanded to meet the specific requirements of our migration prior to being delivered for our use. Once this phase of the project was complete we were provided with the expanded toolkit."

Erik Johnson | Vice President

"We have found the Ispirer team to be knowledgeable and responsive and we have found the tooling to be flexible enough to be easily adapted to our coding conventions."

Informix 4GL code to Microsoft T-SQL Conversion

Converts Informix 4GL functions (*.4gl) to T-SQL functions/procedures (*.sql)

Informix 4GLMicrosoft SQL Server T-SQL

function sample_func(s_char)
#-------------------#
define
    s_char          char(100),
    i               smallint,
    j               smallint,
    r_char          char(100)
 
    let r_char = " "
 
    for i = 1 to 100
        if (s_char[i,i] = " ") then
            continue for
        else
            let r_char = s_char[i,100]
            exit for
        end if
    end for
 
    return r_char
 
end function

FUNCTION  sample_func(@s_char CHAR(2000)) 
---------------------#
RETURNS CHAR(2000)
BEGIN
   DECLARE @i  INT = 0
   DECLARE @j  INT = 0
   DECLARE @r_char  CHAR(100) = ' '
   DECLARE @SWR_i INT
   SET @r_char = SUBSTRB(' ',1,100)
   SET @SWR_i = 1
   while (@SWR_i <= 100)
   begin
      SET @i = @SWR_i
      if(SUBSTRB(@s_char,@i,1))
         continue
   else
      begin
         SET @r_char = SUBSTRB(SUBSTRB(@s_char,@i,101 -@i),1,100)
         BREAK
      end
      SET @SWR_i = @SWR_i+1
   end
   return @r_char
end

Converts comments:

Informix 4GLMicrosoft SQL Server T-SQL

 
  #Single line comments
 
  {
  Multiline comments
  }

 
  --Single line comments
 
  /*
  Multiline comments
  */

Convert data types

Informix 4GL type	Microsoft T-SQL data type
char(length)	CHAR(length)
smallint	INT
integer	INT
date	DATETIME
decimal(n,m)	DECIMAL(n,m)

Converts records to table type variables

Informix 4GLMicrosoft SQL Server T-SQL

 
define c0 record like ctl_f0.*

 
Declare @c0 Table (ctl_f0_id INT, ctl_f0_name VARCHAR(100), ctl_f0_description VARCHAR(1000))

Converts built-in functions, expressions and predicates

	Informix 4GL type	Microsoft T-SQL data type
Ascii function	let a = ascii 223	SET a = CHAR(223)
Clipped function	let a = b clipped	SET a = RTRIM(b)
Date function	let a = date(b)	SET a = CONVERT(DATETIME, b)
Day function	let a = day(b)	SET a = DATEPART(DAY, b)
Mdy function	let a = mdy(b,c,d)	SET a = CONVERT(DATETIME,STR(b) + '-' + STR(c) + '-' + STR(d))
Month function	let a = month(b)	SET a = month(b)
Upshift function	let a = upshift(b)	SET a = UPPER(b)
Using function	let a = b using "######&"	SET a = STR(b,[’9999990’])
Year function	let a = year(b)	SET a = year(b)
Concat expression	let a = b, “cd”,d	SET a = b + [“cd”] + d
Mod expression	let a = b mod 2	SET a = b%2
Substring expression	let a = b[2,2]	SET a = substr(b,2,1)
True/False expression	let a = true let a = false	SET a = true SET a = false
Matches predicate	if (n not matches "[0123456789]") then	if (not regexp_like(n,'[0123456789]')) then

Converts statements of business logic

For example,

For range loop

Informix 4GLMicrosoft SQL Server T-SQL

for i = 1 to 10
…
end for

   SET @i = 1
   while (@i <= 10)
   begin
      …
      SET @i = @i+1
   end

Case statement

Informix 4GLMicrosoft SQL Server T-SQL

case a
  when 1 
  …
  when 2 
  …
  otherwise
  …
end case

IF @a = 1 
      …
ELSE IF @a = 2
      … 
ELSE 
      … 
END

Declare cursor

Informix 4GLMicrosoft SQL Server T-SQL

declare cur_n0 cursor for
  select n0_ch from nkin_a
      where (n0_kau_no = s_kau_no)
      and   (n0_cd = s_cd)

DECLARE CUR_N0 cursor FOR select n0_ch from nkin_a
     where (n0_kau_no = s_kau_no)
     and   (n0_cd = s_cd)

Convert Informix 4GL to Microsoft SQL Server T-SQL

Automated Application Conversion

How it Works

Ispirer Toolkit

1. Preliminary Stage

2. Ispirer Toolkit Customization Stage

3. Use of Ispirer Toolkit

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL
Free Demo License

Ispirer Migration and Modernization Service (Ispirer Service)

Conversion Overview

Informix Database Migration

Get a Project Estimate

Ispirer Toolkit

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL

Ispirer Service

Ispirer Migration Service
Informix 4GL to Microsoft T-SQL

Benefits You Get

Conversion Automation

Flexible Pricing

Use of Modern Technology

What Our Customers Say

Tim Sexton | Project Lead

George Cavanaugh | IT Manager

Vladimir Labar | Software Developer

Yoshiro Suyama | Senior Specialist

Eric Kalabacos | Vice President

Erik Johnson | Vice President

Get in touch with us!

Convert Informix 4GL to Microsoft SQL Server T-SQL

Automated Application Conversion

How it Works

Ispirer Toolkit

1. Preliminary Stage

2. Ispirer Toolkit Customization Stage

3. Use of Ispirer Toolkit

Ispirer Toolkit 10Informix 4GL to Microsoft T-SQL Free Demo License

Ispirer Migration and Modernization Service (Ispirer Service)

Conversion Overview

Informix Database Migration

Get a Project Estimate

Ispirer Toolkit

Ispirer Toolkit 10 Informix 4GL to Microsoft T-SQL

Ispirer Service

Ispirer Migration Service Informix 4GL to Microsoft T-SQL

Benefits You Get

Conversion Automation

Flexible Pricing

Use of Modern Technology

What Our Customers Say

Tim Sexton | Project Lead

George Cavanaugh | IT Manager

Vladimir Labar | Software Developer

Yoshiro Suyama | Senior Specialist

Eric Kalabacos | Vice President

Erik Johnson | Vice President

Get in touch with us!

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL
Free Demo License

Ispirer Toolkit 10
Informix 4GL to Microsoft T-SQL

Ispirer Migration Service
Informix 4GL to Microsoft T-SQL