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 for Linux®, UNIX®, and Windows®, Versions 8.1 and 8.2 |
|
|
DB2 for iSeries™, Versions V5R2, and V5R3 | SQL | Not supported |
DB2 for iSeries, Version V5R3 |
|
Not supported |
DB2 for z/OS® or OS/390®, Version 7, and DB2 for z/OS Version 8 |
|
SQL Scalar is supported for DB2 for z/OS Version 8 |
Derby V10 | Java | Not supported |