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:
  • This list is a superset of the available routine support. Some products do not support Java™ or PL/SQL routines. If your product does not support Java or PL/SQL, you will not see these languages available for selection in the New Stored Procedure wizard.
  • Some products do not support all of the listed data sources. Consult your product's system requirements document for information about supported data sources.

See also Routine support by server type for updates.

Table 1. Database server routine support
Server platform Types of stored procedures supported Types of user-defined functions supported
DB2® Version 9.1, and 9.5 for Linux, UNIX, and Windows
  • SQL
  • Java (JDBC or SQLJ)5
  • SQL (scalar and table) UDFs
  • OLE DB table UDFs (Windows only)
DB2 for Linux, UNIX, and Windows Version 9.7
  • SQL
  • Java (JDBC or SQLJ)5
  • PL/SQL
  • SQL (scalar and table) UDFs
  • MQSeries® table UDFs
  • OLE DB table UDFs (Windows only)
  • PL/SQL
DB2 for Linux, UNIX, and Windows Version 10.1
  • SQL
  • Java (JDBC or SQLJ)5
  • PL/SQL
  • SQL (scalar and table) UDFs
  • MQSeries table UDFs
  • OLE DB table UDFs (Windows only)
  • PL/SQL
  • PL/SQL anonymous blocks6
  • Triggers6
DB2 for iSeries®, Versions V5R3, and V5R4
  • SQL
  • Java (JDBC or SQLJ) using the AS/400® Toolbox for Java JDBC Driver or Universal JDBC driver5
Not supported
DB2 for z/OS® Version 8
  • SQL - external
  • Java (JDBC and SQLJ)5
SQL scalar
DB2 for z/OS Version 9
  • SQL - native
  • SQL - external
  • Java (JDBC and SQLJ)5
SQL scalar
DB2 for z/OS Version 10
  • SQL - native
  • SQL - external
  • Java (JDBC and SQLJ)5
  • SQL scalar
  • Table
  • Non-inline scalar
Derby V10 Java5 Not supported
Informix® Dynamic Server V11.5 and V11.7 SPL SPL
Oracle V10 and V111, 4 PL/SQL PL/SQL
Sybase ESE 1, 2, 3, 4 T-SQL Not supported
Note:
  1. Not supported for IBM® Rational® Application Developer.
  2. The Sybase data source can be Sybase ASE database Version 15.0 or Version 12.5.
  3. The Sybase data source can be a DB2 for Linux, UNIX, and Windows database emulating a Sybase ESE data source with the ANTs Software product DB2 for Linux, Unix and Windows with IBM DB2 SQL Skin Feature for applications compatible with Sybase ASE (IBM DB2 SSacSA).
  4. In Data Studio Version 3.2, routine development support is deprecated for Oracle databases, Sybase databases, and DB2 databases emulating a Sybase database with ANTs IBM DB2 SSacSA. The capability will be removed in a future release.
  5. For Java routines, the routine editor does not support the SQL type ARRAY as an input or output parameter. If you specify an ARRAY as an input or output parameter, the routine editor ignores the parameter.
  6. Debugging triggers and PL/SQL anonymous blocks is supported on DB2 for Linux, UNIX, and Windows Version 10.1 Fix Pack 2 and later databases.

Feedback