Sends Remote Procedure calls (RPCs) to an external destination.
|
exec_rem_proc_clause |
The remote procedure to execute when the other clauses generate output. See EXECUTE REMOTE PROCEDURE Clause for more information. |
|
select_clause |
The select list specifying what to publish. See SELECT Clause for more information. All non-asterisk items in this list must include an AS subclause. |
|
from_clause |
The data sources. See FROM Clause for more information. |
|
matching_clause |
A pattern-matching specification. See MATCHING Clause for more information. |
|
on_clause |
A join condition. See ON Clause for more information. |
|
where_clause |
A selection condition. See WHERE Clause for more information. |
|
group_by_clause |
A partitioning specification. See GROUP BY Clause for more information. |
|
having_clause |
A filter definition. See HAVING Clause for more information. |
|
order_by_clause |
A sequencing definition. See ORDER BY Clause for more information. |
|
limit_clause |
A limit on the number of rows to publish. See LIMIT Clause for more information. |
|
output_clause |
A synchronization specification. See OUTPUT Clause for more information. |
The Remote Procedure statement executes a service defined in the file c8-services.xml. You must have previously configured the service as described in "Enabling Remote Procedure Calls" in the Sybase CEP Installation Guide . This statement is used only to execute procedures on the remote service, not to retrieve data. Data retrieval from remote services is handled by remote subqueries (see Remote Subquery for more information).
The Remote Procedure statement is syntactically similar to the Query statement. It contains a number of clauses that create a query that subscribes to rows from a data stream and then filters and processes the incoming rows. Whenever this process generates output rows, the specified RPC service is invoked and output is sent to the external destination.
The main clauses within a Remote Procedure statement are processed in the following order, which affects the query's output.
FROM clause (with MATCHING conditions, if any).
WHERE clause (with MATCHING conditions, if any).
SELECT clause (in conjunction with GROUP BY, if present).
HAVING clause.
OUTPUT clause.
ORDER BY clause.
LIMIT clause.
INSERT clause.
First configure the service name listed in the EXECUTE REMOTE PROCEDURE clause, as described in "Enabling Remote Procedure Calls" in the Sybase CEP Installation Guide , before using this statement.
If the SELECT clause of the Remote Procedure statement uses the "select all" expression (*) and the FROM clause of the statement lists multiple data sources, the data sources cannot share any column names.
If the SELECT clause contains a list of column names, it must assign an alias to each selected column.
EXECUTE REMOTE PROCEDURE
FROM
GROUP BY
HAVING
LIMIT
MATCHING
ON
ORDER BY
OUTPUT
SELECT
WHERE
EXECUTE REMOTE PROCEDURE "GetManagerApproval"
SELECT
ManagerName AS Name,
ManagerTitle AS Title,
ManagerPhone AS Phone,
EmployeeName AS EmployeeName,
EmployeeTitle AS EmployeeTitle,
TotalSum AS TotalSum
FROM OrdersWithManager
WHERE ManagerName IS NOT NULL AND
(ManagerApprovalLimit IS NULL OR
ManagerApprovalLimit < TotalSum);