Changing the SQL dialect from COBOL to Java & C#In order for the embedded SQL code to work in new system, the dialect has to change from COBOL to Java or C#. This entails converting COBOL host variable (e.g. :FIELD ) to Java and C# standards for passing parameters using '?' or '@' characters.SoftwareMining tools achieve this automatically. |
|
Changing Database VendorAfter the migration of COBOL applications to Java, it may also be desirable to change the underlying database, for example moving from DB2 to Oracle, or MySQL ...The main issue to overcome is the SQL return codes hard-coded in the application which differ between database servers. SoftwareMining migration process allows runtime configuration / substitution of SQL codes - minimizing efforts involved in such database changes. |
|
Migration of COBOL Stored Procedures to Java or C#SoftwareMining tools can be used to migrate COBOL Stored Procedures to Java or C#. The new Java or C# stored-procedures can then be imported into a variety of databases such as Oracle or Microsoft SQL Server. Due to use of Object-Orientation, Exception handling, and framework based architecture, Java / C# stored procedures have better maintainability than standard Transact SQL or PL SQL scripts The new stored procedures are run within the target database environment, leading a better performance. |
|
PerformanceMany SQL COBOL applications are Batch-programs which need to be completed within a set time frame every day.As such the migration of such system would hugely benefit from translation into a design which has performance as one of its main considerations. One approach used by SoftwareMining Translation Tool is to optimizations the generated code by removing the unnecessary statements. For example, DB2 provides a date/time function which provides more precision than COBOL's date/time functions. As such, some COBOL programs contain SQL statements to retrieve date-time from DB2. To continue with this architecture in the translated Java/C# - would introduces additional performance overheads due to network costs associated with Database access. Thus the SoftwareMining Translator replaces such statements with calls to Java/C# library functions returning similar values. |
The Migration of COBOL applications to Java or C# involves:
|
Share this page |
© 2021, SoftwareMining Technologies. All Rights Reserved. "SoftwareMining Technologies" is a trademark of Software Modernization Technologies Ltd (UK). Software Modernization Technologies Ltd. Registered in England company no: 7300248. Reg Offices: 8b Accommodation Road, London NW11 8ED, United Kingdom.