Link to this page

Print this page

Parent topic: BDL programming

SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / BDL programming

Informix specific SQL statements in BDL

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

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.