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
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
You can get to the Stored Procedure Specifications - Settings window from the Stored Procedure - Settings by selecting New or Edit.
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.
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.
In the Description field, type a description of the function of the stored procedure specification. The information in this field is not required.
In the Procedure name field, select the procedure name from the list.
If you use ORACLE and you have defined stored procedures in packages, those stored procedures will not appear in the list. Type the procedure name into the field in the form <package>.procedure, where package is the package name and procedure is the procedure name.
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.
If the stored procedure application uses the input parameter, define the fields as follows:
For ODBC and ORACLE, the input and output variable fields are combined into one field called input/output variables. These database managers can automatically query the database for parameter shapes and display the parameters in the list. Select Get schema from the field's pop-up menu to query the database for parameters.