Use of development tools to create a stored procedure

Workstation-based development tools can help you create, install, and test stored procedures for DB2® for z/OS®.

Stored procedures are portable across the entire family of DB2 servers including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows. If a DB2 subsystem is configured for the creation of SQL and Java stored procedures, you can create these stored procedures with the tools that are available in DB2 Data Studio. These tools also provide steps for building and installing DB2 Java stored procedures on distributed systems. These tools also support read-only access to user-defined functions, triggers, tables, and views.

For more information about how to create stored procedures with development tools, see IBM® Data Studio and Integrated Data Management information center.