| SQL adaptation guide For Genero db 3.6x, 3.8x / Data dictionary | |
Informix® and Genero db have different implementations of the ALTER TABLE instruction. For example, Informix allows you to use multiple ADD clauses separated by commas; this is not supported by Genero db.
Informix:
ALTER TABLE customer ADD(col1 INTEGER), ADD(col2 CHAR(20))
Genero db:
ALTER TABLE customer ADD COLUMN col1 INTEGER ADD COLUMN col2 CHAR(20)
No automatic conversion is done by the database interface. There is no real standard for this instruction ( that is, no common syntax for all database servers). 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.