Parameter Button Details
What is a Parameter?
The parameter values supplied with a procedure call must be constants or variables, a function name cannot be used as a parameter value. Variables can be user-defined or system variables.
To see how to create a parameter, click here.
Follow these steps to create a dataset using a parameter (follow the steps until No. 8).
Click on the Parameter button as shown in the image above:
Users can see the listed options in this window as shown in the image above:
Name
When creating a parameter while creating a dataset, users can set the name as required. Explicitly naming the parameters and assigning the appropriate values to each parameter in a procedure call allows the parameters to be supplied in any order.
Direction
The direction of a parameter is either input (a value is passed into the body of the procedure) or output (the procedure returns a value to the calling program). The default is an input parameter.
Data Type
Parameters must be defined with a data type when they are declared in a CREATE PROCEDURE statement. The data type of a parameter determines the type and range of values that are accepted for the parameter when the procedure is called.
Procedure Type
Initially, users cannot click on the Procedure Type checkbox. Procedure Type is used when users work with ORACLE.
Default Value
A parameter is considered optional if the parameter has a default value specified when it is declared. It is not necessary to provide a value for an optional parameter in a procedure call. The default value of a parameter is used when:
- No value for the parameter is specified in the procedure call.
- The DEFAULT keyword is specified as the value in the procedure call.
Linked Parameter
A linked parameter is used when a user creates a parameter directly from the Parameter section and then links that created parameter here. When the user clicks on the checkbox of Linked Parameter, they will be able to see the created parameter list from the Parameter Section.
Click here to see how to create a parameter directly from the Parameter Section.
Is Hidden
When this option is checked, users cannot see the checkbox of the parameter while previewing it. When the Is Hidden box is checked, the user will see the below pop-up while previewing the dataset.
