Release Notes

25.2 Support for SQL Stored Procedures for z/OS or OS/390

In FixPak 7, the Stored Procedure Builder has enhanced use of the ALTER procedures when building stored procedures for DB2 for z/OS or OS/390, Version 7 (APAR JR16764).

To create an SQL stored procedure for z/OS or OS/390 using the Stored Procedure Builder:

1. Open the Inserting SQL Stored Procedure wizard:
   1. Under a z/OS or OS/390 database connection in the project tree, right-click the stored procedures folder.
   2. Click Insert -> SQL Stored Procedure Using Wizard. The wizard opens.
2. Complete the wizard, specifying the z/OS or OS/390 options:
   • The Collection ID must match what was specified on the BIND PACKAGE(collid) when the JDBC drivers were bound on z/OS or OS/390.
   • The default for the SQL Package is the procedure name, but you can modify this to any name.
3. Click OK. The stored procedure is created and listed in the project tree.
4. Right-click the stored procedure and select Build.