Product documentation
Abstract
The IBM Rational products and IBM Optim products support developing, debugging, and deploying stored procedures and user-defined functions (UDFs). The following table summarizes the types of stored procedures and user-defined functions (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 platform | Types of stored procedures supported | Types of user-defined functions supported |
|---|---|---|
| DB2® Version 9.1, and 9.5 for Linux®, UNIX®, and Windows® |
|
|
| DB2 for Linux, UNIX, and Windows Version 9.7 |
|
|
| DB2 for iSeries®, Versions V5R3, and V5R4 |
|
Not supported |
| DB2 for z/OS® Version 8 |
|
SQL scalar |
| DB2 for z/OS Version 9 |
|
SQL scalar |
| DB2 for z/OS Version 10 |
|
|
| Derby V10 |
|
Not supported |
| Informix® Dynamic Server V11.5 and V11.7 |
|
SPL |
| Oracle V10 and V11 1 |
|
PL/SQL |
| Sybase 1, 2, 3 |
|
Not supported |
Notes:
- Not supported for IBM Rational Application Developer.
- The Sybase data source can be Sybase ASE database Version 15.0 or Version 12.5.
- The Sybase data source can be a DB2 for Linux, UNIX, and Windows database emulating a Sybase ASE data source with the ANTs Software product DB2 for Linux, UNIX and Widows with IBM® DB2 SQL Skin Feature for applications compatible with Sybase ASE (IBM DB2 SSacSA).
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Software Development | Rational Application Developer for WebSphere Software |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.