Release Notes
|In FixPak 7, the following enhancements were added to the Stored Procedure
|Builder for building interpreted Java stored procedures for DB2 for z/OS or
|OS/390, Version 7:
|
- |Actual Cost support
- |Enhanced error message handling
- |Enablement of LINUX/390 servers
- |Support for the @ sign in a stored procedure schema name
|
|Compiled Java stored procedures are not supported in any version of z/OS or
|OS/390 and cannot be created using the Stored Procedure Builder. This
|is true for all versions of DB2.
|Requirements:
|
|To create a Java stored procedure for z/OS or OS/390 using the Stored
|Procedure Builder:
|
- |Open the Inserting Java Stored Procedure wizard:
|
- |Under a z/OS or OS/390 database connection in the project tree,
|right-click the stored procedures folder.
- |Click Insert -> Java 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 Java 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 click Build.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]