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. |