Link to this page

Print this page

Parent topic: BDL programming

SQL adaptation guide for Oracle MySQL 5.x, MariaDB 10.x / BDL programming

Informix-specific SQL statements in BDL

The BDL compiler supports several Informix^® specific SQL statements that have no meaning when using MySQL:

CREATE DATABASE
DROP DATABASE
START DATABASE (SE only)
ROLLFORWARD DATABASE
SET [BUFFERED] LOG
CREATE TABLE with special options (storage, lock mode, etc.)

Solution

Review your BDL source and remove all static SQL statements that are Informix-specific.