Stored procedure and user-defined function 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.
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
  • SQL
  • Java™ (JDBC or SQLJ)
  • SQL (scalar and table) UDFs
  • MQSeries® table UDFs
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 - 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
Related concepts
Creating stored procedures
Creating user-defined functions (UDFs)
Working with stored procedures
User-defined functions (UDFs)
Related tasks
Creating database routines

Feedback