Specific name |
Specify a specific name for the SPECIFIC clause
of the procedure. |
Access |
Select an option for the level of data access
for SQL statements that are included in the procedure. You can select
NO_SQL, CONTAINS_SQL, READS_SQL_DATA, or MODIFIES_SQL_DATA. |
Deterministic |
If checked, specifies that the source procedure
always returns the same results for given argument values (DETERMINISTIC).
If not checked, specifies that the source procedure depends on some
stated values that affect the results (NOT DETERMINISTIC). A DETERMINISTIC
source procedure must always return the same result from successive
invocations with identical inputs. This clause currently does not
impact the processing of the procedure. If this option is not explicitly
specified, the value for the source procedure is used. If this option
is not available at the data source, NOT DETERMINISTIC is the default.
If this option is explicitly specified but does not match the value
for the source procedure, an error is returned. |
External action |
Specifies whether the sourced procedure takes
some action that changes the state of an object that is not managed
by the database manager (EXTERNAL ACTION) or does not take some action
(NO EXTERNAL ACTION). If the NO EXTERNAL ACTION clause is specified,
the federated database uses optimization that assumes that the sourced
procedure has no external impact. If this option is not explicitly
specified, the value for the source procedure is used. If this option
is not available at the data source, EXTERNAL ACTION is the default.
If this option is explicitly specified but does not match the value
for the source procedure, an error is returned. By specifying NO EXTERNAL
ACTION, the system optimizations assume that procedures have no external
impacts. |