Queries Construction and Query Results Usage

To implement queries, you put query text (SQL-like statements) as arguments to an appropriate function from the CEP Query function catalog and place the query functions in one or more rule functions. You can also use bind variables in many clauses to create prepared statements.

When you deploy an agent to query cache data, you can query concepts and simple events in the cache. You cannot query scorecards or time events because they do not exist in the cache. You cannot query the objects in the Rete network itself, or those in the backing store, just those in the cache.

When you deploy an agent to query an incoming event stream, you can query events.

• Query Function Catalog
  A catalog of functions called CEP Query is provided for use in writing and managing queries.
• Functions Within Queries
  Many of the available catalog functions as well as custom functions can be used in a query agent. You can also use rule functions from the same project.
• Bind Variables Usage
  You can place bind variables in the query text argument of the query definition. The values of the variables can be set when a query statement is opened, enabling a single query definition to be reused.