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. |