Link to this page

Print this page

Parent topic: BDL programming

SQL adaptation guide For IBM DB2 UDB 8.x, 9x / BDL programming

Informix^® specific SQL statements in BDL

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

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.