Link to this page

Print this page

Parent topic: BDL programming

SQL adaptation guide For IBM Netezza 1.x / BDL programming

Informix^® specific SQL statements in BDL

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

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 review all SQL statements which are Informix-specific.