The following table summarizes the types of stored procedures and user-defined functions (UDFs) that are supported on various database servers.
Server platform | Types of stored procedures supported | Types of user-defined functions supported |
---|---|---|
DB2 UDB for Linux®, UNIX®, and Windows®, Versions 8.1 and 8.2, and DB2 Version 9.1 for Linux, UNIX, and Windows |
|
|
DB2 for iSeries™, Versions V5R2, V5R3, and V5R4 | SQL | Not supported |
DB2 for iSeries, Version V5R3 and V5R4 | Java (JDBC or SQLJ) using the AS/400® Toolbox for Java JDBC Driver or Universal JDBC driver | Not supported |
DB2 for z/OS® or OS/390®, Version 7, and DB2 for z/OS Version 8 |
|
SQL scalar UDFs are supported for DB2 for z/OS Version 8 |
DB2 Version 9 for z/OS |
|
SQL scalar UDFs |
Derby V10 | Java | Not supported |