The ALTER TABLE instruction

Informix® and IBM® DB2® use different implementations of the ALTER TABLE instruction. For example:

Solution

No automatic conversion is done by the database interface. Read the SQL documentation and review the SQL scripts or the BDL programs in order to use the database server specific syntax for ALTER TABLE.