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