SQLines provides services and tools to help you transfer data, convert database schema (DDL), views, stored procedures (SPL and COBOL), functions, triggers, queries and SQL scripts from IBM DB2 to MariaDB.
Databases:
Character data types:
DB2 | MariaDB | |||
1 | VARCHAR(n OCTETS) | Variable-length string in bytes, 1 <= n <= 32672 | VARCHAR(n) | n <= 65535 in characters ![]() |
2 | VARGRAPHIC(n) | Variable-length UTF-16 string, <= n <= 16336 | VARCHAR(n) |
Binary data types:
DB2 | MariaDB | |||
1 | VARCHAR(n) FOR BIT DATA | Variable-length binary string, 1 ⇐ n ⇐ 32672 | VARBINARY(n) | n ⇐ 65535 |
Numeric data types:
DB2 | MariaDB | |||
1 | DECFLOAT(16 | 34) | IEEE decimal floating-point number | DOUBLE |
Data and time data types:
DB2 | MariaDB | |||
1 | TIMESTAMP(p) | Date and time with fraction, 0 ⇐ p ⇐ 12 ![]() | DATETIME(p) | p ⇐ 6 |
Large objects data types:
DB2 | MariaDB | |||
1 | BLOB(n) | Binary large object, 1 ⇐ n ⇐ 2G | LONGBLOB |