Tip:
Highlight text to annotate it
X
Hello this is Roman Rekun from Ispirer Systems. Today I will show you demo migration from Informix4GL to Java. I will start from showing you
SQLWays Studio. SQLWays Studio is a graphical interface for our core tool SQLWays. It's main purpose is to migrate single file.
For migration we require one script and copy its content to the left pane of the SQLWays Studio.
After this we must choose source as an Informix 4GL and target as Java.
After this we need to press "Run".
Migration will take several seconds.
And now migration is finished and we can check results. For each Informix 4GL script will be created its own database connection.
After migration we will get generally correct Java code that can be compiled in Java Virtual Machine. All call functions
methods are migrated to Java methods.Our tool can handle calling different methods such as
insertdata() and getdata().
Now let's check function getdata().
It is contains one dynamic select statement that concatenates from several strings and contains one variable. Also this method
contains processing of the cursor and fetching results. After migration to Java
will get string variable, that contains composed select statement.
This statement will be stored in the PreparedStatement and executed.
Cursor goes to ResultSet and all result set records are processed as
with function next and assignment to the appropriate variable. Also all exceptions will be
catch by try-catch blocks that our tool will add for each migrated DML statement.
Let's move to the next function insertData().
This method contains only one INSERT statement. It's migrate in the Java to PreparedStatement and each variable that is used in this statement and
that has declaration in this method will be migrated to dynamic parameter for PreparedStatement.
If variable is absent from declaration list this variable will be passed as value to INSERT statement
Appropriate set statement will be applied to the each variable that used in the INSERT statement.
And this is all regarding SQLWays Studio. Now let's see the process
of the migration using SQLWays Commander.
SQLWays Commander is also graphical interface for SQLWays, so results of
the migration from Informix 4GL to Java will be the same as for SQLWays Studio
Main purpose of the SQLWays Commander is to migrate large scope of files.
At the left pane we need to specify folder or separate file for migration.
At the right pane results of the migration will appear.
To start migration we need to specify source of the migration as Informix 4GL and target
of the migration as Java. After this we need to press "Run".
And confirm
results folder.
After migration
is finished we can check thats result of migration
would be the same as for SQLWays Studio
Thank you for your attention. Hope this information will help you in your migration. Good bye.