SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Data dictionary |
Informix® and IBM® DB2® provide triggers with similar features, but the trigger creation syntax and the programming languages are totally different.
Informix triggers define which stored procedures must be called when a database event occurs (before | after insert | update | delete ...), while IBM DB2 triggers can hold a procedural block.
IBM DB2 provides specific syntax to define triggers. See documentation for more details.
Informix triggers must be converted to IBM DB2 triggers "by hand".