Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

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