IBM Support

Routine support by server type

Product Documentation


Abstract

The IBM Rational products and IBM Optim products support developing and deploying stored procedures and user-defined functions (UDFs), as well as debugging for stored procedures and, in some cases, UDFs. The following table summarizes the types of stored procedures and UDFs that are supported on various database servers.

Content

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.

Server platformTypes of stored procedures supportedTypes of user-defined functions supported
DB2® Version 9.5 for Linux®, UNIX®, and Windows®
  • SQL
  • Java (JDBC or SQLJ) 2
  • SQL (scalar and table) UDFs
  • OLE DB table UDFs (Windows only)
DB2 for Linux, UNIX, and Windows Version 9.7 4
  • SQL
  • Java (JDBC or SQLJ) 2
  • 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 4
  • SQL
  • Java (JDBC or SQLJ) 2
  • PL/SQL
  • SQL (scalar and table) UDFs
  • MQSeries table UDFs
  • OLE DB table UDFs (Windows only)
  • PL/SQL
  • PL/SQL anonymous blocks 3
  • Triggers 3
DB2 for iSeries®, Versions V5R3 and V5R4
  • SQL
  • Java (JDBC or SQLJ) using the AS/400® Toolbox for Java JDBC Driver or Universal JDBC driver 5
Not supported
DB2 for iSeries®, Versions V6R1, and V7R1
  • SQL
  • Java (JDBC or SQLJ) using the AS/400® Toolbox for Java JDBC Driver or Universal JDBC driver 2
SQL (scalar and table) UDFs
DB2 for z/OS® Version 8
  • SQL - external
  • Java (JDBC and SQLJ) 2
SQL scalar
DB2 for z/OS Version 9 4
  • SQL - native
  • SQL - external
  • Java (JDBC and SQLJ) 2
SQL scalar
DB2 for z/OS Version 10 4
  • SQL - native
  • SQL - external
  • Java (JDBC and SQLJ) 2
  • SQL scalar
  • Table
  • Non-inline scalar
Derby V10
  • Java 2
Not supported
Informix® Dynamic Server V11.5 and V11.7 4
  • SPL
SPL


Notes:

  1. Not supported for IBM Rational Application Developer.
  2. 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.
  3. 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.
  4. The routine debugger only supports debugging non-inline UDFs.
  5. Starting 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.


[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Stored Procedure and UDF Development","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27036474

Page Feedback