Remote Procedure Call CCL Statement

The CCL statement may be either an EXECUTE REMOTE PROCEDURE statement or may be a subquery that makes a remote query call. Below is a pseudocode example of each:

EXECUTE REMOTE PROCEDURE 'MyRPC1' 
SELECT ...
FROM StreamIn1;
INSERT INTO StreamOut1 (StringCol1)
SELECT RFCOutputAlias.StringCol1
FROM
  (REMOTE QUERY "MyRFC1" SCHEMA StringOnlySchema
      (
      StreamIn1.StringCol1 AS Name
      )
  ) AS RFCOutputAlias, 
  StreamIn1 KEEP 5 ROWS;

The RPC is called each time a new row arrives in any of the streams involved in the CCL statement.

Note that, as with database subqueries, Sybase CEP Server has no knowledge of when information changes on the remote system. The RPC cannot notify Sybase CEP Server that data has changed; the server does not see updated information until a row arrives in one of the query's streams and the server then calls the RPC.

For more information about the syntax of these CCL statements and clauses, see the Sybase CEP CCL Reference Guide .