How to Create Stored procedures in DB2

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

Stored Procedures

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.