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.

Expand

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

CREATE VIRTUAL PROCEDURE CustomerActivity(customerid integer) RETURNS (name varchar(25), activitydate date, amount decimal) AS
    BEGIN
   ...
   END

Copy to Clipboard

Toggle word wrap

Example:Define Virtual Function

CREATE VIRTUAL FUNCTION CustomerRank(customerid integer) RETURNS integer AS
   BEGIN
   ...
   END

CREATE VIRTUAL FUNCTION CustomerRank(customerid integer) RETURNS integer AS
   BEGIN
   ...
   END

Copy to Clipboard

Toggle word wrap

Retour au début

Ce contenu n'est pas disponible dans la langue sélectionnée.

12.12. Procedure Options

Apprendre

Essayez, achetez et vendez

Communautés

À propos de la documentation Red Hat

Rendre l’open source plus inclusif

À propos de Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links