Important: Any machine on which a COBOL stored procedure is executed must have a
Enterprise Server or COBOL Server product installed and licensed. Contact
SupportLine for more information.
To get a stored procedure up and running:
- To set up the initial environment, see
Configuring the Environment for Developing RDBMS Applications on UNIX
- Code and prepare a stored procedure. See the topic
Writing and Preparing Stored Procedures for instructions.
- Code and prepare an application that calls the stored procedure. An SQL statement, CALL, in that application must use the
same parameter list and linkage convention as the stored procedure that it invokes. For instructions, see
Writing and Preparing Applications to Use Stored Procedures.
- Define your stored procedure to the DB2 LUW Server by issuing a CREATE PROCEDURE command, which places a row in the appropriate
system table(s). See
Defining Stored Procedures under DB2 LUW for details.
- Compile and link your stored procedure. See
Compiling and Linking Stored Procedures under DB2 LUW for details.
- Test your stored procedure. See
Testing Stored Procedures under DB2 LUW for details.