Stored procedure properties are shown in the Properties view. You can use the Properties view to modify the properties of a stored procedure.
If the stored procedure already exists in a metadata catalog on a data server and you want the changes that you make to the stored procedure to be reflected in the metadata catalog, you must follow these steps:
The Properties view for a stored procedure contains the following information:
Property | Description |
---|---|
Name | Type the name of the stored
procedure. The name cannot be a single asterisk, even if you specify
it as a delimited identifier ("*"). The name is implicitly or explicitly qualified by a schema. The name, including the implicit or explicit qualifier, must not identify an existing stored procedure at the current server.
The owner of the procedure is determined by how the CREATE PROCEDURE
statement is invoked:
|
Label | Type a label. This label is displayed in visual diagrams, if you use visual diagrams. |
Result set | Specifies the maximum number of query result sets that the stored procedure can return. The default is 0, which indicates that there are no result sets. The value must be 0 or 1. |
Language | Specify the language interface
convention to which the procedure body is written:
|
Parameter style | Specify the convention to use for passing parameters to and returning the value from procedures. |
External name | Type the name of the load module that exists on the data server for loading the stored procedure. |
Deterministic | Specifies whether the stored procedure is deterministic or nondeterministic. |