External procedure -- General

On the General tab:

  1. 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.
  2. Specify a description of the procedure in the Description field. The length can be up to 2000 characters. This field is optional.
  3. 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.
  4. 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.
  5. 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.
  6. 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