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 for Linux®, UNIX®, and Windows®, Versions 8.1 and 8.2
  • SQL
  • Java™ (JDBC or SQLJ)
  • SQL (Scalar and Table)
  • Special table UDFs (MQSeries®)
DB2 for iSeries™, Versions V5R2, and V5R3 SQL Not supported
DB2 for iSeries, Version V5R3
  • Java (JDBC or SQLJ) using the AS/400® Toolbox for Java JDBC Driver
  • 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 is supported for DB2 for z/OS Version 8
Derby V10 Java Not supported
Related concepts
Creating stored procedures
Creating user-defined functions (UDFs)

Comentarios