Federated stored procedure properties

Use the Properties view to view the properties of a federated stored procedure.

For more information about DB2® syntax, see the reference information that is included with each product. There might be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Shows the name.
Label Type a label. This label is displayed in visual diagrams.
Schema Shows the schema under which the stored procedure was created.
Server Shows the server where the stored procedure is stored.
Parameters page
Use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for parameters.
  • Click the New toolbar button to add a new parameter to the bottom of the grid.
  • Click the Delete toolbar button to delete a parameter.
  • Select a parameter in the grid and click Move Up or Move Down to change the order of parameters.
  • Use the grid to modify the properties of a parameter. Double-click a cell or click a check box in a cell to edit the cell contents.
    Property Description
    Name Type a name.
    Data type Select or type a valid data type.
    Mode Select a parameter mode. You can select IN, OUT, or INOUT.
Details page
Property Description
Remote schema Shows the REMOTE_SCHEMA value for this procedure in the system catalog.
Remote procedure name Shows the REMOTE_PROCEDURE value for this procedure in the system catalog.
Remote package name Shows the REMOTE_PACKAGE value for this procedure in the system catalog.
Remote unique ID Shows the REMOTE_UNIQUE_ID value for this procedure in the system catalog.
Options page
Property Description
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.
Documentation page
Shows information about the object.
Related tasks
Viewing the properties or source code of federated stored procedures

Feedback