SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Data dictionary |
Both Informix® and IBM® DB2® support stored procedures and user functions, but the programming languages are totally different.
Informix implements the SPL language, while DB2 allows you to write stored procedures or user defined functions in the DB2 SQL or with an external language, such as JAVA, C or C++.
Informix stored procedures must be converted to IBM DB2 "by hand".