Stored procedure and user-defined function support by DB2 Universal Database server type

The following table summarizes the types of stored procedures and user-defined functions (UDFs) that are supported on various DB2 UDB servers.

Restriction: DB2 UDB does not fully support stored procedures and user-defined functions that contain distinct types (user-defined types) as parameters.

DB2 server platform Types of stored procedures supported Types of user-defined functions supported
DB2 Universal Database for Linux, UNIX, and Windows, Versions 8.1 and 8.2

  • SQL

  • Java/SQLJ

  • SQL (Scalar and Table)

  • Special table UDFs (MQSeries)

DB2 Universal Database for iSeries, Versions V5R1, V5R2, and V5R3 SQL Not supported
DB2 Universal Database for z/OS or OS/390, Version 7, and DB2 Universal Database for z/OS Version 8

  • SQL

  • Java/SQLJ

Not supported

 

Parent topic

DB2 stored procedures

 

Parent topic

DB2 user-defined functions (UDFs)

 

Related concepts

Overview of DB2 stored procedures tasks
Tips for developing DB2 stored procedures
Developing DB2 user-defined functions
Using DB2 user-defined functions in applications

 

Related tasks

Creating DB2 stored procedures
Preparing to debug a DB2 SQL stored procedure
Creating DB2 user-defined functions using a wizard
Creating DB2 user-defined functions for WebSphere MQ
Changing stored procedure build settings for DB2 Universal Database for z/OS
Building DB2 routines
Changing run settings for DB2 routines
Running DB2 routines

Related reference
Stored procedure task restrictions
User-defined function catalog by DB2 Universal Database server
User-defined function support by type