Database Guide : Database Help : Database windows and dialogs : Stored procedure windows : Stored Procedure Specifications - Settings (DB/2)
Stored Procedure Specifications - Settings (DB/2)
Use the Stored Procedure Specifications - Settings window to specify or change the parameters of the stored procedure specification that you are defining or editing. A stored procedure specification defines the inputs, outputs, and filename of a particular stored procedure file. Once defined, you associate a stored procedure specification with a Stored Procedure part and the input fields and output fields are added as attributes of the Stored Procedure part's public interface.
Fields
•Name
Pop-up menu
Push buttons
Select OK to update the part and close the settings view window.
Select Apply to update the part with the changes and remain in the settings view.
Tasks
Opening Stored Procedure Specifications - Settings
You can get to the Stored Procedure Specifications - Settings window from the Stored Procedure - Settings by selecting New or Edit.
Name
In the Name field, type the name of your stored procedure specification. You must specify a name in this field.
Each stored procedure specification requires a unique name. It cannot contain DBCS characters. If you change the name of an existing stored procedure specification, a new one is created with the new name, and the old one continues to exist.
Call type
In the Call type field, select the DARI radio button to use DARI call type or SQL call to use SQL call type.
If you select DARI, then you need to specify input and outpur variables separately. If you select SQL call, then you specify all variables for the stored procedure in the Input variables field.
Description
In the Description field, type a description of the function of the stored procedure specification. The information in this field is not required.
Procedure name
In the Procedure name field, select the procedure name from the list.
Input string label
If the stored procedure file that this stored procedure specification is assocated with uses an input string parameter, type the descriptive name for that parameter in the Input string label field. The name is added to the visual interface of the stored procedure and can be used as the source or target of a connection.
Input/Output variables
If the stored procedure application uses the input parameter, define the fields as follows:
1. Use the field's pop-up menu to add, edit, or delete variables.
2. Make your selection from the menu and define the input field in the host variable dialog that displays.
Last modified date: 05/24/2022