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 |