SQLines provides services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to MySQL.
We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl, PHP, Python, Linux shell and other applications. SQLines can also assist you to convert COBOL stored procedures and programs to MySQL procedural SQL, Java, Python or any other language.
Databases:
Technical information on migration from IBM DB2 to MySQL:
Converting data types:
DB2 | MySQL | ||
CHAR | Fixed-length character string | CHAR | |
DATE | Date (year, month and day) | DATE | |
INT, INTEGER | 32-bit integer | INT, INTEGER | |
SMALLINT | 16-bit integer | SMALLINT | |
TIMESTAMP | Date and time | DATETIME | |
VARCHAR | Variable-length character string | VARCHAR |
Converting functions:
DB2 | MySQL | |||
1 | CURRENT DATE | CURRENT_DATE | Get current date | CURRENT_DATE |
Converting SQL SELECT statement:
DB2 | MySQL | |
SYSIBM.SYSDUMMY1 table | A single row, single column dummy table | FROM clause removed |
Converting SQL statements:
DB2 | MySQL | |
VALUES expression | Construct a result set | SELECT expression |