Routine support by server type

The following table summarizes the types of stored procedures and user-defined functions (UDFs) that are supported on various database servers.
Restriction:
  • DB2® does not fully support stored procedures and user-defined functions that contain distinct types (user-defined types) as parameters.
  • This list is a superset of the available routine support. Some products do not support Java or PL/SQL routines. Some products do not support Oracle.
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, and 9.5 for Linux, UNIX, and Windows
  • SQL
  • Java™ (JDBC or SQLJ)
  • SQL (scalar and table) UDFs
  • MQSeries® table UDFs
  • OLE DB table UDFs (Windows only)
  • XML UDFs
DB2 for Linux, UNIX, and Windows Version 9.7
  • SQL
  • Java (JDBC or SQLJ)
  • PL/SQL
  • SQL (scalar and table) UDFs
  • MQSeries table UDFs
  • OLE DB table UDFs (Windows only)
  • XML UDFs
  • PL/SQL
DB2 for iSeries®, Versions 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 - external
  • Java (JDBC and SQLJ)
SQL scalar UDFs are supported for DB2 for z/OS Version 8
DB2 for z/OS Version 9
  • SQL - native
  • SQL - external
  • Java (JDBC and SQLJ)
SQL scalar
Derby V10 Java Not supported
Oracle V10 and V11 PL/SQL PL/SQL

Feedback