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.
How to Create Stored procedures in Zo/s:
- Working with stored procedures in Data Studio (IBM Data Studio)
- Create, test, and deploy a DB2 SQL procedure with Integrated Data Management Tools (IBM Data Studio)
- Developing DB2 for z/OS stored procedures (IBM Data Studio)