SQL procedure -- General
On the General tab:
- Specify the name by which you want the procedure to be known in the Procedure field.
The name can be the same as a function
or procedure that exists in the same schema. However, the signature of the procedure must not be the same as any other procedure
that exists in the same schema.
- Specify a description of the procedure in the Description field. The length can be up to 2000 characters. This field is
optional.
- If you want to specify the number of result sets that the procedure can return, specify the number
in the Maximum number of result sets field. If you do not specify a number, the system limit is used.
- If you want the same result to be returned every time the procedure is called with the same values for the parameters,
select Same result returned from successive calls with identical input (Deterministic). This will save the values that the
procedure returns. Those values are automatically returned if the procedure is called with the same parameters, thereby saving
system resources.
- If you want to commit the changes automatically when the procedure is done, select
Commit changes when control returns to caller.
- In the Data Access field, select Contains SQL if the function
or procedure changes and reads SQL data.
Select No SQL if the function or procedure does not read, write, or change SQL data.
Select Reads SQL data if the function or procedure reads, but does not write or change, SQL data.
Select Modifies SQL data if the function or procedure changes, but does not read, SQL data.
- Specify a specific name for the procedure in the Specific name field. This name must be
different from other functions or procedures in the same schema. If you do not specify a specific name,
the system will generate one for you.
Next, select: