Parser upgrades

A parser is the core technology that enables the translation of one database system into another. Each enhancement to the parser improves conversion accuracy and flexibility, ensuring smoother migrations.

This month’s parser updates include support for:

  • Informix
  • Teradata
  • COBOL
  • DB2
  • Sybase ASE
  • C#
  • Java

These upgrades help minimize manual adjustments and ensure more reliable conversions across different database environments.

Conversion improvements

DB2 for z/OS (OS390) to PostgreSQL

improved conversion of partition by range, ROWID data type

DB2 to PostgreSQL

improved conversion of DELETE with FETCH and LIMIT clauses, dynamic statements, casting of integer parameters, multiple columns update, exit handlers with IF, procedure parameters

Informix to Oracle

improved conversion of DATETIME data types, INTERVAL data types, import process. Implemented multiprocess data export.

Informix to PostgreSQL

improved conversion of exceptions with IF and rollbacks

Sybase ASE to SQL Server

improved conversion of join operators, selects with group by, labels, defaults, aggregate functions in having clause, index hints with isolation level, + operator

Sybase ASE to Oracle

improved conversion of CURRENT_TIME and NOW, SECONDS_BETWEEN(), DAYS_BETWEEN()

Oracle to PostgreSQL

improved conversion of object names inside packages, pipeline function usage, timestamp computing, package global variables, aggregate functions, UNPIVOT

Oracle to JavaL

improved conversion of MEMBER OF operator, NVL() as a parameter. A new mechanism of conversion was implemented as a default conversion

Oracle to SQL Server

improved conversion of NULL inside string values

COBOL to C#

improved framework for current direction, SPACES LOW-VALUES statements, PERFORM THRU TIMES, string variables in IF

PowerBuilder to C#

improved conversion of drop down data object, trigger event, custom event, class instance

Delphi to C#

added generation of project file for Visual Studio 2022 for WinForms/WPF .NetCore. Improved multiprocess conversion for current direction. Added option that allows commenting controls unsupported by our tool. Improved conversion of IF constructions, CreateOleObject, On Create event, On Show event

Delphi to Java

added conversion of sizeof() function

SQL Server to Oracle

improved conversion of identity functions (@@IDENTIY, SCOPE_IDENTIY, IDENT_CURRENT), current_transaction_id()

SQL Server to PostgreSQL

improved code conversion speed for current direction. Improved conversion of table functions, zero and empty string castings, schema names in code, merge with using, recursive triggers, xml_nodes, computed columns with datetimeoffset, SYSDATETIME(), CURRENT_TIMESTAMP, GETDATE(), exist(), user defined data types, CTE statements, dblinks, schema_name(), NCHAR(), schema usage, UNION ALL, casting for integer procedure parameters, nested subqueries with temporary tables, subqueries in a resultset, @@datefirst

SQL Server to Java

improved conversion of ESQL

C++ to C#

updated framework. Improved conversion of parameters of reference type

Informix 4GL to Java

improved conversion of dynamic variables and their initialization for Vaadin, packages, generation of Constant class for Vaadin, Close window, display form, open form, ui.window is null, close form, terminate dialog, current window is, start dialog, record ... end record, open window, open form