此内容没有您所选择的语言版本。
12.12. Procedure Options
You can use the following options when creating procedures. See "create procedure" in Section A.7, “Productions”. Any others properties defined will be considered as extension metadata.
|
Property
|
Data Type or Allowed Values
|
Description
|
|---|---|---|
|
UUID
|
string
|
Unique Identifier
|
|
NAMEINSOURCE
|
string
|
In the case of source
|
|
ANNOTATION
|
string
|
Description of the procedure
|
|
UPDATECOUNT
|
int
|
if this procedure updates the underlying sources, what is the update count, when update count is >1 the XA protocol for execution is enforced
|
Example 12.7. Example:Define Procedure
CREATE VIRTUAL PROCEDURE CustomerActivity(customerid integer) RETURNS (name varchar(25), activitydate date, amount decimal) AS
BEGIN
...
END
Example:Define Virtual Function
CREATE VIRTUAL FUNCTION CustomerRank(customerid integer) RETURNS integer AS
BEGIN
...
END