Routine development is not supported for every available data source. See Stored procedure and user-defined function support by server type for details.
Using the New Stored Procedure wizard, you name the stored procedure, specify the stored procedure language, define the structure and SQL statement, and specify the parameters and additional options. For Java stored procedures that target DB2 for z/OS® Version 9, you can specify JAR file Java path information. You can also customize the generated source code by specifying files that contain code fragments. You can specify the following types of code fragments:
To create a stored procedure from a data development project: