Release Notes
|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:
|
- |Open the Inserting SQL Stored Procedure wizard:
|
- |Under a z/OS or OS/390 database connection in the project tree,
|right-click the stored procedures folder.
- |Click Insert -> SQL Stored Procedure Using Wizard.
|The wizard opens.
|
- |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.
|
- |Click OK. The stored procedure is created and listed in
|the project tree.
- |Right-click the stored procedure and select Build.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]