Products Support Documentation Download
Creating a Stored Procedure

A stored procedure is defined using the create procedure statement. Argument variables to be passed into a stored procedure through the call statement can be declared to be input, output, or both input and output. A stored procedure can optionally return to the calling program one or more select statement result sets.