See also Routine support by server type for updates.
| Server platform | Types of stored procedures supported | Types of user-defined functions supported |
|---|---|---|
| DB2® Version 9.1, and 9.5 for Linux, UNIX, and Windows |
|
|
| DB2 for Linux, UNIX, and Windows Version 9.7 |
|
|
| DB2 for Linux, UNIX, and Windows Version 10.1 |
|
|
| DB2 for iSeries®, Versions V5R3, and V5R4 |
|
Not supported |
| DB2 for z/OS® Version 8 |
|
SQL scalar |
| DB2 for z/OS Version 9 |
|
SQL scalar |
| DB2 for z/OS Version 10 |
|
|
| Derby V10 | Java5 | Not supported |
| Informix® Dynamic Server V11.5 and V11.7 | SPL | SPL |
| Oracle V10 and V111, 4 | PL/SQL | PL/SQL |
| Sybase ESE 1, 2, 3, 4 | T-SQL | Not supported |