Link to this page

Print this page

Parent topic: BDL programming

SQL adaptation guide For SQLite 3.5.x, 3.6.x / BDL programming

Informix-specific SQL statements in BDL

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

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 which are Informix specific.